Do not display "#N/A" result

T

tbrownusa

Is there a way to hide the "#N/A" result in a VLOOKUP calculation when the
result is not possible?
 
F

Fred Smith

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

How to correct a #N/A in vlookup 1
Installation error. 1
WordPad blocked content 2
Replace #N/A with 0 1
VLOOKUP - 0 instead of # N/A 9
Can I add a formula or function to Vlookup? 1
How To Have A Cell Be Blank If... 2
Turning off automatic calculation 0

Top