VLOOKUP - masking #N/As

[jcl408]

Is there an easy way to add something into the VLOOKUP function so that if it returns #N/A it will say "Item Not Found" or something instead of #N/A?

 

[VoG]

Try

=IF(ISNA(your formula),"Not available",your formula)

 

[yogeshmaney]

try


=if(iserror(your formula),"Item Not Found", your formula)

 

[jcl408]

try


=if(iserror(your formula),"Item Not Found", your formula)

That works! Thanks all