The Excel lookup and reference Functions are used to cross reference between different data. The Lookup and Reference Formulas in Excel can refer to a cell or array to match the value in another cell or array.
Complete List of Excel Lookup and Reference Functions (A to Z)
All Excel lookup and reference functions are mentioned below in alphabetical order:
Function | Description |
ADDRESS Function | Cell address based on a given row and column number. |
AREAS Function | Number of areas in a given reference. |
CHOOSE Function | A value or reference from a list of options based on the index number. |
CHOOSECOLS Function | Specified columns from an array or range. |
CHOOSEROWS Function | Specified rows from an array or range. |
COLUMN Function | Column number of the selected cell reference. |
COLUMNS Function | Number of columns in an array or reference. |
DROP Function | Removes a specified number of rows or columns from the start or end of an array. |
EXPAND Function | Expands an array to a specified number of rows and columns. |
FIELDVALUE Function | All matching fields from the linked data type specified in the value argument. |
FILTER Function | Filters a range of data based on one or more criteria that you specify. |
FORMULATEXT Function | Formula in text format from the cell reference. |
GETPIVOTDATA Function | Specific data from a pivot table. |
HLOOKUP Function | Searches for a value in the top row of an array and return the value from a row you specify. |
HSTACK Function | Combining each of the array horizontally into one array. |
HYPERLINK Function | Hyperlink from a given destination and link text. |
IMAGE Function | Insert a image in a cell from a source location along with alternative text. |
INDEX Function | Value in a range or array based on the row and column numbers. |
INDIRECT Function | Reference specified by a text string. |
LOOKUP Function | Looks up a value in a single column or row to find a value from the same position in another column or row. |
MATCH Function | Searches a specified value in a range and returns the position of that value in the array or range. |
OFFSET Function | Value of a cell or range which is a specified number of rows and columns from a cell or range. |
ROW Function | Row number in a given range. |
ROWS Function | Number of rows in a given range. |
RTD Function | Real time data from a program which supports COM automation. |
SORT Function | Sorts the data of a range in ascending or descending order. |
SORTBY Function | Sorts the data of a range based on the values in a corresponding range. |
TAKE Function | Specified number of contiguous rows or columns from the start or end of a range. |
TOCOL Function | Range in a single column. |
TOROW Function | Range in a single row. |
TRANSPOSE Function | Rotates the data in rows into columns and columns into rows. |
UNIQUE Function | Rotates the data in rows into columns and columns into rows. |
VLOOKUP Function | Search for a value in the first column of a range and return a corresponding value from a specified column in the same row. |
VSTACK Function | Combines arrays vertically and in sequence into a larger array. |
WRAPCOLS Function | Wraps the provided row or column of values by columns after a specified number of values. |
WRAPROWS Function | Wraps the provided row or column of values by rows after a specified number of values. |
XLOOKUP Function | Search for a specified value from a table or range of cells. |
XMATCH Function | Relative position of a value in an array or range. |