Formulas to Index a Value by Matching Multiple Column in Excel 365!!
Tags: excelformula, excelformulas
Published: 2020-10-15 12:04:29

---
title: Formulas to Index a Value by Matching Multiple Column in Excel 365!!
published: true
date: 2020-10-15 07:59:43 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-index-a-value-by-matching-multiple-column-in-excel-365/
---

## Excel Formulas to Index a Value by Matching Multiple Column:

This page describes, how to use **Formulas to Index a Value by Matching Multiple Column in Excel Office 365**. 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)

## Formula Syntax:

- Use the below Formula to Index a Value by Matching Multiple Columns in Excel Office 365.

**{=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)($A$2:$A$4,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(1,[MMULT](https://geekexcel.com/use-mmult-function-in-microsoft-excel-365-simple-methods/)(–($B$2:$D$4=F2),[TRANSPOSE](https://geekexcel.com/how-to-use-transpose-function-in-microsoft-excel-365/)([COLUMN](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/)($B$2:$D$4)^0)),0)),””)}**

### Example:

- We enter the section in **Column A** and input names are given in **Column B, C, and D**.
- Then apply the given formula to get output.
- After applying the formula, it will display the result in the selected **Cell G2** as shown below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/op17.png)

## Syntax Explanations:

- **IFERROR** – The [**IFERROR  Function**](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/) is used to show the custom result when the formula generates an error otherwise it will display the standard results.
- **INDEX** – The main purpose of this function is to get a value in a list or table based on the location. For more details about the [**INDEX Function**](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/).
- **MATCH** -In Excel, to locate the position of a lookup value in a row, column, or table we will use the [**MATCH Function**](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/).
- **MMULT** – The Excel **MMULT Function** returns the matrix products of two arrays. It performs matrix Multiplication of two arrays. Read more on the [**MMULT Function**](https://geekexcel.com/use-mmult-function-in-microsoft-excel-365-simple-methods/).
- **TRANSPOSE** – This function helps to convert a vertical range to a horizontal range or horizontal range to vertical range. It simply changes the orientation of the given array or range. Read more on the [**TRANSPOSE Function**](https://geekexcel.com/how-to-use-transpose-function-in-microsoft-excel-365/).
- **COLUMN** – It returns the column number for a reference. For example, Column C5 will be returned in 3 because C is the third column in the spreadsheet. Read more on [**COLUMN Function**](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/).

## Verdict:

In this article, we will explain how to use **Formulas to Index a Value by Matching Multiple Column in Excel Office 365**. Don’t forget to leave your valuable **feedback.** Thank you for visiting **[Geek Excel](https://geekexcel.com/)!!**