Thread: IsError help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default IsError help

Good morning Excel Masters,

Quick question - how do I write the following so that it returns a blank
cell if the cell it is referencing is blank?

=VLOOKUP(F2,[Vehicle_Data.xls]Master_Sales_Lookup!$B$2:$J$89,2,FALSE)

Right now I get a #N/A

Thanks