Use XLOOKUP with multiple sheets
To use XLOOKUP with multiple sheets, you can specify the sheet name followed by an exclamation point (!) in front of the cell range. For example, if you …
xlookup
XLOOKUP Function in Excel
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! Speed up your spreadsheet by changing your default lookup function. Add a 4th and 5th argument!