vlookup - replace #N/A with text - Excel 2003
Use this structure instead of your original =VLOOKUP(...) formula:
=IF(ISERROR(VLOOKUP(...)),"textstring",VLOOKUP(... ))
Regards,
Stefi
€˛Charlotte Howard€¯ ezt Ć*rta:
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
|