getting ride of #n/a result from vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How does one best do away with the #n/a symbol when that is what the vlookup
returns

Is there a way to tell it to return "blank" or a designated value when the
voolkup does not come up with an exact match

note always use "false" - exact match.

Hey I appreciate your time
 
Put the vlookup inside a test for NA; instead of =vlookup(...), use
=if(isna(vlookup(...)),"",vlookup(...))
 
Had a simialr prob recently. Used a combination of IF and ISERROR to remove
the error messages. Try something similar to =IF(ISERROR(FIND("EI",'Previous
Project'!L5)),'Previous Project'!L5," "), this returned the value of cell L5
 
try this sort of thing:
IF(ISERROR(VLOOKUP(A21,'Paste Tiq'!$A$1:$T$700,7,FALSE)),"
",VLOOKUP(A21,'Paste Tiq'!$A$1:$T$700,7,FALSE))
 
You must log in or register to reply here.

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

Eliminate #N/A in Vlookup formulas 2
Vlookups to return a N/A value 3
VLOOKUP AND #N/A 10
Vlookup and If statement help 1
VLOOKUP PROBLEM 2
Vlookup #n/a 6
VLOOKUP using FALSE returning blanks and #N/A 1
VLOOKUP - return 0 instead of "#N/A" 3

Back
Top