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

or probably

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


--


Regards,


Peo Sjoblom





"Luke M" wrote in message
...
=IF(ISBLANK(A20),"",VLOOKUP(A20,EmpInfo,2))

--
Best Regards,

Luke M


"roxiemayfield" wrote:

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?