Complete List of Excel Lookup and Reference Functions, References and Examples
Excel comes with multiple Lookup and Reference functions that let you find matching values.
This page provides a complete Excel Lookup and Reference functions list. Each of the function links will take you to a dedicated page, where you will find a description of the function, with examples of use.
The Lookup and Reference Functions help you to work with arrays of data, and are particularly useful when you need to cross reference between different data sets. They perform tasks such as providing information about a range, returning the location of a given address or value, or looking up specific values.
Here’s a full list of BuiltIn Lookup and Reference Functions in Excel and their Descriptions.
Click each of the function link to see detailed example.
Data Lookup Functions 

HLOOKUP  Looks up a supplied value in the first row of a table, and returns the corresponding value from another row 
VLOOKUP  Looks up a supplied value in the first column of a table, and returns the corresponding value from another column 
LOOKUP  Searches for a specific value in one data vector, and returns a value from the corresponding position of a second data vector 
GETPIVOTDATA  Extracts data stored in a Pivot Table 
CHOOSE  Returns one of a list of values, depending on the value of a supplied index number 
MATCH  Finds the relative position of a value in a supplied array 
Row / Column / Area Information 

ROW  Returns the row number of a supplied range, or of the current cell 
COLUMN  Returns the column number of a supplied range, or of the current cell 
ROWS  Returns the number of rows in a supplied range 
COLUMNS  Returns the number of columns in a supplied range 
AREAS  Returns the number of areas in a supplied range 
Functions To Return References to Cell Ranges 

ADDRESS  Returns a reference, in text format, for a supplied row and column number 
INDEX  Returns a reference to a cell (or range of cells) for requested rows and columns within a supplied range 
INDIRECT  Returns a cell or range reference that is represented by a supplied text string 
OFFSET  Returns a reference to a range of cells that is a specified number of rows and columns from an initial supplied range 
Others 

HYPERLINK  Creates a hyperlink to a document in a supplied location. 
TRANSPOSE  Performs a transpose transformation on a range of cells (i.e. transforms a horizontal range of cells into a vertical range and vice versa) 
RTD  Retrieves realtime data from a program that supports COM automation 
FORMULATEXT  Returns a formula as a string (New in Excel 2013) 