Transpose Values Based on Multiple Lookup Criteria in Excel Office 365!!
Tags: excelpreface, transposevaluesinexc, excelbasics, exceltutorials
Published: 2021-01-19 11:37:37

---
title: Transpose Values Based on Multiple Lookup Criteria in Excel Office 365!!
published: true
date: 2021-01-19 10:34:39 UTC
tags: ExcelPreface,TransposevaluesinExc,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/transpose-values-based-on-multiple-lookup-criteria-in-excel-office-365/
---

Sometimes you may want to transpose the values in an Excel spreadsheet and don’t know how to do that. In this situation, we are here to help you for **transposing values from columns to rows**  **based on multiple lookup criteria**. We will assist you to understand the steps to achieve this task easily with the help of [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. 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)

## Syntax and its Explanation:

- You can use the [**INDEX** function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/) with the [**MATCH** Function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/) to look up the value with multiple criteria and then find the transpose of the result.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)($D$2:$D$10,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(1,($B$2:$B$10=$F4)\*($C$2:$C$10=G$3),0))**

- **INDEX function –** This function returns the value at a given position in a range or array. INDEX is frequently used together with the MATCH function.
- **MATCH function –** It is used to locate the position of a lookup value in a row, column, or table.

## Practical Example:

The following example will help you to understand how it works.

- You need to [open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) where you need to apply this formula.
- Let us assume the example information of students and their marks scored in monthly tests.

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

- We are going to get the student marks based on a specific month ( **Jan** , **May, Dec** ).
- To do this, you need to place the cursor in the cell where you want to get the output value. We have placed the cursor in the active **cell G4**.

![Place the cursor](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_h04aw6jwJD.png)<figcaption id="caption-attachment-21143">Place the cursor</figcaption>

- Then **apply** the above-given **formula** and **press** the **CTRL** + **SHIFT** + **Enter** keys.

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

- You can drag the mouse from the **cell G4 to I6** to fill the result as shown in the below screenshot.

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

## Verdict:

In this tutorial, we have described the steps to **[transpose](https://geekexcel.com/how-to-use-transpose-function-in-microsoft-excel-365/) values from columns to rows**  **based on multiple lookup criteria in Excel Office 365**. Feel free to share your **valuable queries** and **worthwhile feedback** with us. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!