LOOKUP AND REFERENCE FUNCTIONS

4 ADDRESS : Returns a reference as text to a single cell in a worksheet
4 AREAS : Returns the number of areas in a reference
4 CHOOSE : Chooses a value from a list of values
4 COLUMN : Returns the column number of a reference
4 COLUMNS : Returns the number of columns in a reference
4 GETPIVOTDATA : Returns data stored in a PivotTable
4 HLOOKUP : Looks in the top row of an array and returns the value of the indicated cell
4 HYPERLINK : Creates a shortcut or jump that opens a document stored on a network server, an intra/intnet
4 INDEX : Uses an index to choose a value from a reference or array
4 INDIRECT : Returns a reference indicated by a text value
4 LOOKUP : Looks up values in a vector or array
4 MATCH : Looks up values in a reference or array
4 OFFSET : Returns a reference offset from a given reference
4 ROW : Returns the row number of a reference
4 ROWS : Returns the number of rows in a reference
4 RTD : Retrieves real-time data from a program that supports COM automation
4 TRANSPOSE : Returns the transpose of an array
4 VLOOKUP : Looks in the first column of an array and moves across the row to return the value of a cell