Nested IF statements that work in EXCEL 2007 don\'t work in EXCEL 2013 I am havi

Question

Nested IF statements that work in EXCEL 2007 don't work in EXCEL 2013

I am having a problem with EXCEL 2013 and the usse of nested IF stateements. Such statements worked in the previous 2007 version but give erroneous answers in the 2013 version. This is the formula that I am trying to use in cell B3:

=IF(ISBLANK($A3)," ",IF(VLOOKUP($A3,EMP,1)=$A3,VLOOKUP($A3,EMP,2),"NF"))

The formula returns NF rather than tthe information listeed in the 2nd column of the EMP data range. (Yes, the correct data is there.)

What is the correct formula to use in EXCEL 2013?   Thanks!

Explanation / Answer

There is nothing wrong with the formula syntactically. Buut is the data in EMP the same? Is the data sorted in ascending order based on the first column in EMP?

Try the following:

=IF(ISBLANK($A3),"",IFERROR(VLOOKUP($A3,EMP,2,FALSE),"NF"))

which should also work in Exceel 2007.

Note the change from " " (one space) to "" (nuull string) if ISBLANK(A3) is true. This might simplify any formulas that depend on B3.....

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.