Index Match for Complex Lookups
INDEX function Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.
MATCH function returns the relative position of an item in an array that matches a specified value in a specified order.
In the previous article, you got acquainted with the basics of index and match functions
Example 1:
Index Match for Complex Lookups
We can find a specific value in Excel table with combined index and match.
Consider the table below:
Name | Age | Height | Weight |
Olivia | 25 | 210 | 180 |
Noah | 25 | 205 | 235 |
Oliver | 27 | 195 | 205 |
Elijah | 22 | 198 | 185 |
James | 29 | 199 | 231 |
William | 29 | 201 | 240 |
Benjamin | 21 | 202 | 235 |
Lucas | 25 | 200 | 238 |
Henry | 22 | 204 | 19 |
We want to get Oliver’s age from the table above:
Here, a combination of index and match functions should be used.

Example 2:
We want to get Elijah’s height from the table above:

Example 3:
We want to get William’s weight from the table above:
