Use INDEX and MATCH in Excel to perform a two-column lookup. Note: the array formula above looks up the salary of James Clark, not James Smith, not James Anderson.

To lookup a value in a two-dimensional range, use INDEX and MATCH in Excel. Below you can find the sales of different ice cream flavors in each month.

This example teaches you how to perform a two-column lookup in Excel. See the example below. We want to look up the salary of James Clark, not James Smith, not James Anderson.

By default, the VLOOKUP function performs a case-insensitive lookup. However, you can use INDEX, MATCH and EXACT in Excel to perform a case-sensitive lookup.

To perform a last to first search, set the sixth argument to -1 (see example below). Explanation: this XLOOKUP function returns the salary of Mia Reed, not Mia Clark.

The VLOOKUP function is one of the most popular functions in Excel. This page contains many easy to follow VLOOKUP examples.

The VLOOKUP function only looks to the right. To look up a value in any column and return the corresponding value to the left, simply use INDEX and MATCH.

To find the closest match to a target value in a data column, use INDEX, MATCH, ABS and MIN in Excel. Use the VLOOKUP function in Excel to find an approximate match.

Learn all about Excel's lookup & reference functions, such as VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE.

The XMATCH function in Excel enhances the MATCH function by adding new features, making it ideal for finding the position of items within arrays or cell ranges. This guide will detail how to use …