Vlookup through multiple sheets of data

[Bandicoot]

Hi,

Is it possible to have a Vlookup that looks at two tabs? I’m using the current formula in my spreadsheet;

=IFERROR(VLOOKUP(LEFT(A12,3)&"*",ModelNumber!A:E,3,FALSE),"no match")

There is approx. 500k rows of data on the ModelNumber sheet. I have however had to add approx. 1 million more rows of data to this, which I’ve had to move some onto a new sheet called “ModelNumber2” due to exceeding the number of rows within a sheet.

Is there a way to edit my current lookup to get it to also search through the new sheet for the exact same criteria as above? So effectively the Vlookup is looking in the data in both sheets?

Thanks,

[kbkumar]

Hi Bandicoot,

Try this:

=IFERROR(IFERROR(VLOOKUP(LEFT(A12,3)&"*",ModelNumber!A:E,3,FALSE),VLOOKUP(LEFT(A12,3)&"*",ModelNumber2!A:E,3,FALSE)),"No Match")

Hope it helps.

[Bandicoot]

Hi kbkumar ,

Thank you - that's worked great, just what I was after.

[kbkumar]

You are welcome. Please mark the thread as solved