Excel 2010 Bible

Part VII: Appendixes

926

TABLE A.9

Lookup & Reference Category Functions

Function What It Does

ADDRESS Returns a reference as text to a single cell in a worksheet.

AREAS Returns the number of areas in a reference.

CHOOSE Chooses a value from a list of values.

COLUMN Returns the column number of a reference.

COLUMNS Returns the number of columns in a reference

GETPIVOTDATA Returns data stored in a PivotTable.

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.

HYPERLINK Creates a shortcut that opens a document on your hard drive, a server, or the Internet.

INDEX Uses an index to choose a value from a reference or array.

INDIRECT Returns a reference indicated by a text value.

LOOKUP Returns a value from either a one-row or one-column range or from an array.

MATCH Returns the relative position of an item in an array.

OFFSET Returns a reference offset from a given reference.

ROW Returns the row number of a reference.

ROWS Returns the number of rows in a reference.

RTD Returns real-time data from a program that supports COM automation.

TRANSPOSE Returns the transpose of an array.

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.

TABLE A.10

Math & Trig Category Functions

Function What It Does

ABS Returns the absolute value of a number.

ACOS Returns the arccosine of a number.

ACOSH Returns the inverse hyperbolic cosine of a number.

AGGREGATE** Returns an aggregate in a list or database.

ASIN Returns the arcsine of a number.

56_474877-bapp01.indd 92656_474877-bapp01.indd 926 3/29/10 11:49 PM3/29/10 11:49 PM