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.

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 …

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.

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.

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.

By default, the XLOOKUP function performs a first to last search (nothing new). To perform a last to first search, set the sixth argument to -1 (see example below).

To perform advanced lookups, you'll need INDEX and MATCH. Maybe this is one step too far for you at this stage, but it shows you one of the many other powerful formulas Excel has to offer.

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

- Tax Rates: This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel. - Index and Match: Use INDEX and MATCH in Excel and …