Thread: Vlookup - N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Canon Canon is offline
external usenet poster
 
Posts: 55
Default Vlookup - N/A

Excel 2007
I am using the following formula;
=VLOOKUP(B3,Info!$A$1:$B$2,2,FALSE)
If B3 remains blank, or has something other than what is in the look up
table, I want to get rid of the #N/A that shows up in the cell so the cell
remains blank.