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