One way:
=if(isna(VLOOKUP(I6,Fire,2,FALSE)),"",VLOOKUP(I6,F ire,2,FALSE))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"shannon c" wrote in message
...
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.
--
shannon c