Lookup & Reference Functions
ADDRESS(row_num,column_num,abs_num,a1,sheet_text) | Returns a reference as text to a single cell in a worksheet. |
AREAS(reference) | Returns the number of areas in a reference. |
CHOOSE(index_num,value1,value2,…) | Chooses a value from a list of values. |
COLUMN(reference) | Returns the column number of a reference. |
COLUMNS(array) | Returns the number of columns in a reference. |
HLOOKUP(lookup_value,table_array,row_index_num,…) | Looks in the top row of a table and returns the value of the indicated cell. |
HYPERLINK(link_location,friendly_name) | Creates a shortcut that opens a document stored on a network computer or the Internet. |
INDEX(…) | Uses an index to choose a value from a reference or array. |
INDIRECT(ref_text,a1) | Returns a reference indicated ... |
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.