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.

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

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.