Learn How to Lookup Entire Row in Microsoft Excel
The main purpose of this formula is to lookup and retrieve an entire row. Here we will learn how to perform the lookup for the entire row in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the INDEX, and MATCH functions, you can able to perform a lookup and retrieve an entire row.
So, with the help of this formula, you can able to perform the lookup for an entire row in the given data range in the workbook in Microsoft Excel.
General Formula to Lookup Entire Row
=INDEX(data,0,MATCH(value,headers,0))
The Explanation to Lookup Entire Row
So we know that with the help of the given formula above you can able lookup and retrieve an entire row. Here we will learn how to perform lookup for the entire row in the given data range in the workbook in Microsoft Excel.
As we know the MATCH function is used to identify the row index, then INDEX retrieves the entire row by setting the row number to zero. Working from the inside out, MATCH is used to get the row index.
So now you have learned how to perform the lookup for an entire row in the given data range in the workbook in Microsoft Excel.