XLOOKUP in Microsoft Excel
How to use XLOOKUP in Microsoft Excel instead of V LOOKUP? Basically, XLOOKUP needs 2 arrays, one for the lookup to search for the match and the second is the return array from which the value is returned, whereas VLOOKUP uses a single table array followed by a column index number. So we can use XLOOKUP if the value that is being searched for is not the first column of the table. In the below example, we can see that column I is the first array for the search to look for a match and this need not be the first column and column H is the second array which is the return array.