Do not display "#N/A" result

  • Thread starter Thread starter tbrownusa
  • Start date Start date
T

tbrownusa

Is there a way to hide the "#N/A" result in a VLOOKUP calculation when the
result is not possible?
 
The standard was is:
=if(isna(vlookup(....)),"",vlookup(.....))

If you have XL2007, you can use:
=iferror(vlookup(....),"")

Regards,
Fred.
 

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

vlookup resulting in #N/A 2
Temp variables within formulas? 2
If condition not met get #N/A 5
Remove #n/a in vlookup to sum results 6
#N/A 4
VLOOKUP #N/A result 2
Replace #N/A with 0 1
VLOOKUP - 0 instead of # N/A 8

Back
Top