Go Back

How to Lookup an Entire Row in Excel

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.

=INDEX(data,MATCH(value,array,0),0)

–  that is the generic formula

You can also use:  LOOKUP(value,lookup_range,[result_range])

More Explanation

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.

Example

Following the instance is given above, let’s try out the Lookup function on some rows in a spreadsheet.

Step 1

Supply the data for each cell, including the Order No, Names, Price & Quality.

Figure 1: Excel shows the values entered for each row.

Step 2

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.

Step 3

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.

Notes

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. 

 

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I have a problem regarding to Lookup entire row
Solved by I. F. in 26 mins
I need vba to grab an entire row of values based on a criteria, then hide the selected cells' entire columns.
Solved by G. A. in 11 mins
how can i remove an entire row from a pivot table?
Solved by V. U. in 27 mins

Leave a Comment

avatar