Try something like this...

=IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....))

Hope this helps!

In article ,
"frank" wrote:

is there a way to avoid getting the #N/A as a response
when I do a Lookup? i would simply rather return a blank.