- XLookup with Structured Table References | Microsoft Community Hub
I have another table where I would like to use XLOOKUP to search that table and return some information from it Cells in the second table have references like this: =XLOOKUP ( [@Name],MasterlistTable [@Name],MasterlistTable [@ [Phone 1]],"error") They all return a "value not available" error
- Step by Step Guide on Excel for XLOOKUP (With Examples)
XLOOKUP helps you find a value in a range or array It's better than VLOOKUP, HLOOKUP, and some uses of INDEX-MATCH Syntax: lookup_value: The value you want to search for lookup_array: The range column where Excel will search return_array: The range column from which you want to retrieve a value
|