Thread: #N/A Error on VLOOKUP
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default #N/A Error on VLOOKUP
=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