Excel Lookup and Reference Functions

SORT Function

The SORT function in Excel allows users to sort the contents of a range or array based on specified criteria.

»

FILTER Function

The FILTER function in Excel dynamically extracts data from a range (or array) based on specific conditions. It filters and displays only the rows or values that meet the criteria you set.

»

VLOOKUP Function

The VLOOKUP Function in Excel searches for a value in the first column of a specified range and returns a value in the same row from another column.

»