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?