vlookup question

[HROBERTSON]

If the item I'm looking up doesn't exist in the range, is there a way to
return blank (or ""), instead of N/A? Any help is greatly appreciated.

Thank You!

 

[pinmaster]

Hi,

Yes:

=IF(ISNA(vlookup_formula),"",vlookup_formula)


Cheers!
Jean-Guy

 

[Dave F]

=IF(ISERROR(VLOOKUP([your vlookup]),"",VLOOKUP([your vlookup]))

Dave