(Part 5 of 5. See Part 4.)
The most powerful and flexible way to look up data in Excel is the INDEX-MATCH method. It relies on two Excel functions:
=INDEX(reference, row_num, column_num)
- reference—a range of cells
- row_num—the row in reference from which to return data.
- column_num—the column in reference from which to return data.
If reference is one row or column, INDEX can use this syntax: =INDEX(reference, cell_num)
=MATCH(lookup_value, lookup_array, match_type)
- lookup_value—The value to match in lookup_array.
- lookup_array—A range of cells with data.
- match_type—Specifies how Excel matches the lookup_value with values in the lookup_array. For exact matches, always use 0 for this argument.
The figure below shows the INDEX-MATCH method in action…