Thank you! I think that will work.

"Pete_UK" wrote:

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

On Dec 7, 8:15 pm, roxiemayfield
wrote:
Still giving me the #N/A



"Luke M" wrote:
=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?- Hide quoted text -

- Show quoted text -