Lookup & Reference Functions


Lookup & Reference Functions
Lookup & Reference
Functions
Description
     ADDRESS Returns the address of a cell in a worksheet, given specified row and column numbers.
     AREAS Returns the number of areas in a reference.  The reference can include a single cell, a range of contiguous cells, or a range of non-contiguous cells.
     CHOOSE Determines which value from a list of values is to be retrieved based on its position in the list
Column and Row Functions
     COLUMN Returns a Number Rounded away from Zero to the Nearest Multiple of significance
     COLUMNS Rounds a number down toward zero to the nearest multiple of significance
     ROW Rounds a number down to the nearest integer
     ROWS Rounds a decimal number away from zero to the nearest even integer
     ODD Rounds a decimal number away from zero to the nearest odd integer
     OFFSET Rounds a number to a specified number of digits
     TRANSPOSE Always rounds a number down
Search Functions  
     INDEX Used to retrieve the value from a single row or the value from any two-dimensional range.  It doesn't use a lookup value it just retrieves the value from the specified location.
     LOOKUP Searches a single row or column for a value and then returns a value from the same position in another single row or column range.
     HLOOKUP Horizontal Lookup.   Uses a lookup value to search the top row of a table or array for a matching value then returns the value from the same column as the row you specify.
     VLOOKUP Least Common Multiple (Returns the least common multiple of integers)
     MATCH Returns the result of a number raised to a power