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.
|