Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelTwo-way Lookup in Microsoft Excel

# Two-way Lookup in Microsoft Excel

This article explains Two-way lookup in Microsoft Excel and how you can use it effectively.

### Two-way Lookup

Using the Index and Match function you can get a value in a two-dimensional range. This is known as the Two-way Lookup.

Here use two-match functions along with the index function.

=INDEX(lookup_array, MATCH(â€¦.), MATCH(â€¦.))

Lets take a look on the example given below

In this example, there are two match function which finds the position of the two lookup values (F7-MAY and F8-PAY2) from two different range(A2:A6 and B1:C1) respectively. And finally the index function returns the value from that particular location.

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021