Vlookup where reference data is on multiple worksheets within same workbook

[TJMMARTELLA]

short of combining all worksheets on one.. I'm assuming there is a way to include multiple ranges for the reference data. they're all formatted the same.

thanks kindly for any help

 

[JackDanIce]

Without seeing your sheet, difficult to suggest solution.

What are the multiple ranges?
What sheets are they on?

Can you give an example of what the formula looks like inside a cell, using 2 ranges? That can be used to then suggest how to expand.
Include what cell is it in and what is the name of the sheet the cell is on

 

[t0azt]

you can do an iferror(vlookup(sheet1),vlookup(sheet2)) nesting iferrors as needed