VLOOK up between two lists

[Jake_1]

Hey,

I'm struggling to find a formula that allows me to VLOOKUP a value in list1, and if the value isn't present, then look in list2.

I've attached an example.

[BadlySpelledBuoy]

What about something like:

=IFERROR(VLOOKUP(),VLOOKUP())

So you put the first table VLOOKUP in the first VLOOKUP and if it errors because it cannot be found then the IFERROR function will cause it to look in the second VLOOKUP.

BSB

[Shareez Saleem]

The above solution is the best one.
If you want to do a lookup with the sheet name, try this

Please Login or Register  to view this content.

[Jake_1]

Amazing thanks peeps!