Iserror and Vlookup

G

Guest

I have a Vlookup function that is looking up cell C1 in a seperate Range.
But sometimes the text in C1 cant be found in the Data Range, so then I need
it to look up D1, and if that cant be found than E1, and if that cant be
found than F1.

I think I need to use an Iserror function, but I am having a hard time
getting it to work.

Is something like this right
=IF(ISERROR(Vlookup(C1,DATA,2,FALSE)),"",IF(VLOOKUP(D1,DATA,2,FALSE),""IF(VLOOKUP(E1,DATA,2,FALSE),"",IF(VLOOKUP(F1,DATA,2,FALSE)

What am I missing??

Mark
 
J

JE McGimpsey

One way:

=IF(ISNA(VLOOKUP(C1,DATA,2,FALSE)), IF(ISNA(VLOOKUP(D1,DATA,2,FALSE)),
IF(ISNA(VLOOKUP(E1,DATA,2,FALSE)), IF(ISNA(VLOOKUP(F1,DATA,2,FALSE)),
"", VLOOKUP(F1,DATA,2,FALSE)), VLOOKUP(E1,DATA,2,FALSE)),
VLOOKUP(D1,DATA,2,FALSE)), VLOOKUP(C1,DATA,2,FALSE))
 

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

If, then, vlookup 1
if and vlookup functions 3
if and vlookup formula 9
Help With VLOOKUP 2
VLOOKUP displaying "NO ANSWER" instead of "0" 2
Vlook-up in report with column Expansion 5
Iserror with if(or & Vlookups 5
vlookup formatting problem 1

Top