vlookup - replace #N/A with text - Excel 2003

[Charlotte Howard]

Hi,
Is it possible to replace a #N/A result with a particular text string? I
know I could use Find/Replace, but I really don't want to lose the formula.
Thanks for any help
Charlotte

 

[David Biddulph]

=IF(ISNA(your_formula),"your text string",your_formula)

 

[Stefi]

Use this structure instead of your original =VLOOKUP(...) formula:

=IF(ISERROR(VLOOKUP(...)),"textstring",VLOOKUP(...))
Regards,
Stefi

„Charlotte Howard†ezt írta: