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

C

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
 
S

Stefi

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

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

„Charlotte Howard†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace #N/A with 0 1
Replace #N/A 2
Need help with a formula, please!!! 2
Vlookup with no #N/A? 5
VLOOKUP - 0 instead of # N/A 8
VLOOKUP isn't working properly in Excel on Mac 1
How come it say "Microsoft Excel cannot find any data to replace"? 4
Remove #N/A in vlookup result 5

Top