Below listed are the various lookup / reference functions of Microsoft Excel 2007.
The ADDRESS function returns the text representation of a cell address with the given row and column numbers.
The AREAS function returns the number of areas from the given reference.
The CHOOSE function returns a value from the available value list on the basis of given value.
The COLUMN function returns the column number of the given reference.
The COLUMNS function returns the number of columns in a cell reference.
TThe HLOOKUP function returns an item in a row and reproduces the same item in the column from the row of the table mentioned by the user.
The HYPERLINK function returns the shortcut information which opens the saved document in the internet or in the local communications network.
INDEX function picks a particular value from a range of data based on the row & column number specified.
The INDIRECT function returns the source indicated by the text characters or series.
LOOKUP function looks for specific information from a list and returns a related item.
MATCH function shows the position of an item in a list.
The OFFSET function returns the reference to a range, which is a specified number of rows and columns from another range or cell.
The ROW function returns the row number of a cell reference.
The ROWS function returns the number of rows in a cell reference or array.
The TRANSPOSE function converts the vertical cell series as horizontal cell series.
The VLOOKUP function explores an item in the given column and replicates that item in the row from another column of the table mentioned by the user.