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

Two-way Lookup in Microsoft Excel

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.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

You cannot copy content of this page