Excel Formulas to Lookup Entire Row ~ Complete Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-01-18 11:13:42

---
title: Excel Formulas to Lookup Entire Row ~ Complete Tutorial!!
published: true
date: 2021-01-18 10:37:36 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-lookup-entire-row/
---

Normally, we can look up and return a matching value from a range of data by using the [**LOOKUP function**](https://geekexcel.com/use-lookup-function-in-microsoft-excel-365-simple-methods/). In this tutorial, we will talk about how to **lookup the entire row** and return the value based on certain criteria in Excel by using the [**INDEX**](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/) and [**MATCH**](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/) functions. Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Lookup entire row](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Lookup-entire-row.png)](https://geekexcel.com/?attachment_id=21099#main)<figcaption id="caption-attachment-21099">Lookup entire row</figcaption>
## Generic Formula:

- Use the below formula to look up and retrieve an entire row in Excel.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(data,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(value,range,0),0)**

## Syntax Explanations:

- **INDEX** – The **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)** returns the value at a given position in a range or array.
- **MATCH** – In Excel, this function will locate the position of a lookup value in a row, column, or table. Read more on the **[MATCH function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)**.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Range** – It represents the input ranges in your worksheet.
- **Value** – It is the criteria that want to get the values.
- **Data ** – It is the input range from your worksheet.

## Practical Example:

Now, we are going to see the steps to find the value from the entire row based on the given criteria.

- First, we will give the input values from [**Column**](https://geekexcel.com/calculate-the-table-columns-excel/) **B** to **Column**  **F**.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Ranges-13.png)<figcaption id="caption-attachment-21095">Input Ranges</figcaption>

- Here, we need to find the value based on the given criteria shown below.

![Criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Criteria-11.png)<figcaption id="caption-attachment-21096">Criteria</figcaption>

- Enter the formula in the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-12.png)<figcaption id="caption-attachment-21097">Enter the formula</figcaption>

- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- Finally, it will find and return the value based on the given criteria. Refer to the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-31.png)<figcaption id="caption-attachment-21098">Result</figcaption>

## Wrap-Up:

From this short tutorial, we have described the simple formula used to **lookup the entire row in Excel** by using the **INDEX** and **MATCH** functions. Hope you like it. Please state your **query** in the below **comment** section. We will assist you. Click here to know more about **[Geek Excel!!](https://geekexcel.com/)** And **[Excel Formulas](https://geekexcel.com/excel-formula/)!!**

### Read Also:

- **[Excel Formulas to Lookup Multiple Criteria with INDEX and MATCH!!](https://geekexcel.com/excel-lookup-multiple-criteria-with-index-and-match/)**
- **[Excel Formulas to Lookup the Values between Two Numbers!!](https://geekexcel.com/lookup-values-between-two-numbers-excel/)**