Vlookup through multiple sheets of data

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,