formula for multiple 3 V lookups

[fishep6]

I am looking for a formula that will do a vlookup on one set of data, if that doesn't get a result it will then do a second vlookup and finally if that is blank it will conduct a third vlookup.

I have managed to do this based on 2 vlookups using the formula below but I cant get it to do the third look up

=IFERROR(VLOOKUP(B3,'June 18'!B:C,2,FALSE),VLOOKUP(B3,'June 18'!E:F,2,FALSE))

the third lookup I need to do is VLOOKUP(B3,'June 18'!H:I,2,FALSE) as the answer will always be in one of the 3 searches.

I tried

=IFERROR(VLOOKUP(B3,'June 18'!B:C,2,FALSE),VLOOKUP(B3,'June 18'!E:F,2,FALSE),VLOOKUP(B3,'June 18'!H:I,2,FALSE))

but this brings up an error, is the formula maxed at 2 vlookups?

if so is there another way around this that I appear blind to?

Many thanks

 

[Eric W]

Try:

=IFERROR(VLOOKUP(B3,'June 18'!B:C,2,FALSE),IFERROR(VLOOKUP(B3,'June 18'!E:F,2,FALSE),VLOOKUP(B3,'June 18'!H:I,2,FALSE)))

 

[fishep6]

brilliant thank you, so simple!

 

[Eric W]

Glad to help!