View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default vlookup question

Hi,

Yes:

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


Cheers!
Jean-Guy

"HROBERTSON" wrote:

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!