Lookup and Reference Functions

The following table lists all the Lookup & Reference functions −

S.No.	Function and Description
1	ADDRESS Returns a reference as text to a single cell in a worksheet
2	AREAS Returns the number of areas in a reference
3	CHOOSE Chooses a value from a list of values
4	COLUMN Returns the column number of a reference
5	COLUMNS Returns the number of columns in a reference
6	FORMULATEXT Returns the formula at the given reference as text
7	GETPIVOTDATA Returns data stored in a PivotTable
8	HLOOKUP Searches for a value in the top row of a table and then returns a value in the same column from a row you specify in the table
9	HYPERLINK Creates a shortcut that opens a document on your hard drive, a server, or the Internet
10	INDEX Uses an index to choose a value from a reference or array
11	INDIRECT Returns a reference indicated by a text value
12	LOOKUP Returns a value either from a one-row or one-column range or from an array
13	MATCH Returns the relative position of an item in an array
14	OFFSET Returns a reference offset from a given reference
15	ROW Returns the row number of a reference
16	ROWS Returns the number of rows in a reference
17	RTD Returns real-time data from a program that supports COM automation
18	TRANSPOSE Returns the transpose of an array
19	VLOOKUP Searches for a value in the leftmost column of a table and then returns a value in the same row from a column you specify in the table