#N/A Error on VLOOKUP
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 -
|