In the previous post, we have seen how to find the two-way approximate match lookup in Excel? Similarly, here we are going to see the simple formula used to find the two-way lookup with INDEX and MATCH function in Excel. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- To look up the value in a table, you can use the below formula.
=INDEX(data,MATCH(value,rows,1),MATCH(value,columns,1))
Syntax Explanations:
- INDEX – In Excel, the INDEX function will return the value at a given position in a range or array.
- MATCH – This function helps to locate the position of a lookup value in a row, column, or table. Read more on the MATCH function.
- Data – It represents the input values in the range.
- Values – It is the criteria that want to be found.
- 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.
Example:
Let’s consider the below example image. Here we will show a simple example for your reference.
- First, we will give the input values in Column B to Column G.
- Then, enter the above-given formula into the formula bar section.
- Finally, we will get the result in the selected cell.
Verdict:
From this short tutorial, we have described the simple formula used to find the two-way lookup value with the INDEX and MATCH functions in Excel. Please state your query to the below comment section. Thank you so much for visiting our site. Continue learning on *Geek Excel!! **and Excel Formulas *!! **
Top comments (0)