Perfect.
Thanks so much!
"Gary''s Student" wrote:
Use the general form:
=IF(ISNA(VLOOKUP()),"",VLOOKUP())
--
Gary''s Student
"SWEdwards" wrote:
I use a lot of VLOOKUP functions in formulas and am frustrated by the #N/A
results whenever the value I'm looking for isn't in the reference list range.
Is there a simple way to have a formula leave the result blank if the value
isn't found?
|