Lookup and reference functions (reference)

Click one of the links in the following list to see detailed help about the function.

Function

Description

ADDRESS function

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

AREAS function

Returns the number of areas in a reference

CHOOSE function

Chooses a value from a list of values

COLUMN function

Returns the column number of a reference

COLUMNS function

Returns the number of columns in a reference

GETPIVOTDATA function

Returns data stored in a PivotTable report

HLOOKUP function

Looks in the top row of an array and returns the value of the indicated cell

HYPERLINK function

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet

INDEX function

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

INDIRECT function

Returns a reference indicated by a text value

LOOKUP function

Looks up values in a vector or array

MATCH function

Looks up values in a reference or array

OFFSET function

Returns a reference offset from a given reference

ROW function

Returns the row number of a reference

ROWS function

Returns the number of rows in a reference

RTD function

Retrieves real-time data from a program that supports COM automation

Note    This function is not available in Microsoft Excel Starter 2010

For more information about the features available in Excel Starter, see Excel Starter feature support.

TRANSPOSE function

Returns the transpose of an array

VLOOKUP function

Looks in the first column of an array and moves across the row to return the value of a cell

Applies To: Excel 2010, Excel Starter, Excel Online, SharePoint Online



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language