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