vlookup question
 

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!

vlookup question
 

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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!

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!