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

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

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

=IF(ISNA(your_formula),"your text string",your_formula)
--
David Biddulph

"Charlotte Howard" wrote in
message ...
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

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