Searches a range or an array and returns an item
corresponding to the first match it finds.

Looks for a value in the first column of a table and returns
a value in the same row from a specified column.

Returns a range filtered on criteria you define.

Selects and returns specified columns from an array or range.

Returns the value of a cell in a table at the intersection of
the provided row and column number.

Searches for a specified item in a range and returns the relative
position of that item.

INDEX and MATCH are better together enabling dynamic row and column lookups.

Master the Excel functions and formulas using real world examples that will set you apart from the crowd.