Enter the formula =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)). Replace return_range with the range of cells that contains the data you want to return.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

XLOOKUP is Excel’s modern fix for everything VLOOKUP got wrong. It’s simpler, more flexible, and available in Excel 365 and ...