Learn How to Get XLOOKUP Match Any Column in Microsoft Excel
The main purpose of this formula is to perform a lookup by matching a value in any one of several columns. Here we will learn how to get XLOOKUP to match any column in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the XLOOKUP, and MMULT functions, you can able to perform a lookup by matching a value in any one of several columns.
So, with the help of this formula, you can able to get the XLOOKUP to match any column in the given data range in the workbook in Microsoft Excel.
General Formula to Get XLOOKUP Match Any Column
=XLOOKUP(1,MMULT(–(codes=K5),SEQUENCE(COLUMNS(codes),1,1,0)),group)
The Explanation to Get XLOOKUP Match Any Column
So we know that with the help of the given formula above, you can able to perform a lookup by matching a value in any one of several columns.
Here we will learn how to get XLOOKUP to match any column in the given data range in the workbook in Microsoft Excel. As we know, here, the formula uses the XLOOKUP function to perform the lookup.
Here the number 1 is the lookup value, and the named range group is the return array. The trick here is the lookup array, which is created with the MMULT function.
So now you have learned how to get XLOOKUP to match any column in the given data range in the workbook in Microsoft Excel.