View Single Post
  #1   Report Post  
shannon c shannon c is offline
Junior Member
 
Posts: 6
Default VLOOKUP returns #N/A

The Data sheet contains a column with numeric values. The lookup table deliberately does not contain all of the values found in the Data sheet. When the formula
=VLOOKUP(I6,Fire,2,FALSE)
is applied the result is #N/A when the value in I6 is not found in "Fire" lookup.
Is there a way to have the result display as a blank cell instead of #N/A when this condition occurrs.

Thanks in anticipation.