Iserror and Vlookup
 

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(VLOOKU P(D1,DATA,2,FALSE),""IF(VLOOKUP(E1,DATA,2,FALSE)," ",IF(VLOOKUP(F1,DATA,2,FALSE)

What am I missing??

Mark

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))



In article ,
"ShineboxNJ" wrote:

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(VLOOKU P(D1,DATA,2,FALSE),""IF(VLOO
KUP(E1,DATA,2,FALSE),"",IF(VLOOKUP(F1,DATA,2,FALSE )