Using the ‘XLOOKUP’ function is very easy.
Unlike the ‘VLOOKUP’ and ‘HLOOKUP’ functions, there’s no need to specify the column number to return.
To illustrate further, let’s use this dataset as an example:
Let’s say you would like to use the ID as the lookup value and return all the available data about that ID.
For this purpose, let’s use “505”.
Now, all you have to do is supply the parameters with the appropriate cell references:
- ‘lookup_value’ – C3
- ‘lookup_array’ – C7:C16
- ‘return_array’ – D7:G16
Write the formula on the cell where you would like to display the results. In this case, the result starts at cell D3: