#N/A Error on VLOOKUP

[roxiemayfield]

I have this formula:

=VLOOKUP(A20,EmpInfo,2)

If A20 is Blank, I want the cell blank - instead I am getting #N/A

What am I doing wrong?

 

[Luke M]

=IF(ISBLANK(A20),"",VLOOKUP(A20,EmpInfo,2))

 

[Peo Sjoblom]

=IF(ISNA(VLOOKUP(A20,EmpInfo,2)),"",VLOOKUP(A20,EmpInfo,2))

or probably

=IF(ISNA(VLOOKUP(A20,EmpInfo,2,0)),"",VLOOKUP(A20,EmpInfo,2,0))


--


Regards,


Peo Sjoblom

 

[roxiemayfield]

Still giving me the #N/A

=IF(ISBLANK(A20),"",VLOOKUP(A20,EmpInfo,2))

 

[roxiemayfield]

This one is giving me FALSE unless the cell is blank, then I am still getting
#N/A

 

[Pete_UK]

Try it this way:

=IF(A20="","",VLOOKUP(A20,EmpInfo,2))

then copy down if required. Ensure that A20 and other cells below it
are blank, and not containing spaces.

Hope this helps.

Pete

 

[roxiemayfield]

Thank you! I think that will work.

Try it this way:

=IF(A20="","",VLOOKUP(A20,EmpInfo,2))

then copy down if required. Ensure that A20 and other cells below it
are blank, and not containing spaces.

Hope this helps.

Pete

 

[Pete_UK]

Glad to hear it - thanks for feeding back.

Pete

Thank you! I think that will work.






- Show quoted text -