Eliminate #N/A in Vlookup formulas

K

kkeim

I need Vlookup to return a blank if there is no value to be found in the
table. IE: Vlookup,a2,"table",12,false returns #N/A if there is not exact
match in "table" (Another spreadsheet). How do I eliminate this? It's driving
me nuts!
 
F

Francis

try the traditional formula

=IF(ISNA(VLOOKUP(A2,"table",12,0)),"",VLOOKUP(A2,"table",12,0))

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 

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

Vlookups to return a N/A value 3
Use & with two formulas 2
Vlookup and If statement help 1
VLOOKUP source values are a formula result. Getting #N/A 7
VLOOKUP PROBLEM 2
Errors encountered when using If & Vlookup formulas 2
VLOOKUP AND #N/A 10
Help with N/A in formulas 3

Top