The lookup ENTIRE row function comes in handy when you want to find the value for certain rows in Excel. This function is especially important when you want to get a matched and uniform value for data. Getting the match value of a data could be a complex job without this function.
Lookup Entire Row in Excel
Syntax using INDEX and MATCH together and LOOKUP
There are different types of syntaxes for the lookup function as seen above.
– that is the generic formula
You can also use:
The Excel LOOKUP function can also be very useful in returning a particular value from a targeted range. This range could be in a row, column or in any type of array. The LOOKUP is typified and tagged as a Reference/Lookup Function in the Microsoft Excel spreadsheet.
When you are using the lookup function in a spreadsheet, you can simply input it as part of a bigger formula in a cell. The LOOKUP function is an easy way to getting the value of any row you want as fast and possible. It also positively affects your productivity when working on a spreadsheet.
For instance, we may want to check out the entire row or column in the spreadsheet containing the stock of a store.
Following the instance is given above, let’s try out the Lookup function on some rows in a spreadsheet.
Supply the data for each cell, including the Order No, Names, Price & Quality.
Figure 1: Excel shows the values entered for each row.
Now, let’s use this formula “= LOOKUP (10251, A1:A6, B1:B6)”. The Lookup entire row function returns all the results for each selected cell.
Figure 2. Enter the formula for Lookup entire row function.
Tap Enter and the result will be displayed un a cell
Figure 3: Lookup entire row function returns all the results for each selected cell.
If you’re trying to get results for more than a cell, you’d be required to enter a different formula for a multi-cell array.
Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free.