Thread: #N/A Error on VLOOKUP
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roxiemayfield roxiemayfield is offline
external usenet poster
  
Posts: 21
Default #N/A Error on VLOOKUP
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?
Reply With QuoteReply With Quote