How to use the XLOOKUP/VLOOKUP/HLOOKUP functions to search a table on a separate sheet from a formula.(Microsoft Excel)
How to use the XLOOKUP/VLOOKUP/HLOOKUP functions to search a table on a separate sheet from a formula.
Steps
Use the sample below.
Set up a reference to another cell in the format below.
Sheet name!Cell address
The sample formula is as follows.
=XLOOKUP(A2,List!A2:A5,List!B2:B5)
“!” may be set by keystroke or automatically when another sheet is selected by mouse designation.
---