Return every column of the matching record, not just one value.
Copy this formula
=XLOOKUP(A2, Ids, DataRange)When the return array of XLOOKUP is a multi-column range, it returns and spills the whole matching row. It's the cleanest way to pull a full record by key onto another sheet.
=XLOOKUP(A2, Orders[ID], Orders[[Name]:[Total]])→spilled rowReturns the full order record.
Use INDEX with a 0 column argument and MATCH for the row: =INDEX(DataRange, MATCH(A2, Ids, 0), 0).
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.