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

How to correct a #N/A in vlookup 1
Same forumula returns both 0 & N/A 2
Use & with two formulas 2
VLOOKUP source values are a formula result. Getting #N/A 7
VLOOKUP & Data Validation 0
VLookup + IF 5
Vlookup Returning Zero For Every Cell 3
Vlookups to return a N/A value 3

Top