Hi!

One way:

=IF(COUNTIF(A1:A100,lookup_value),VLOOKUP(lookup_v alue,A1:B100,2 0),"")

Biff

"SWEdwards" wrote in message
...
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?