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
|