Page 262 - Excel Data Analysis

14 537547 AppB.qxd 3/4/03 11:57 AM Page 248

APPENDIX

EXCEL FUNCTION QUICK REFERENCE

(CONTINUED)

LOOKUP & REFERENCE FUNCTIONS

FUNCTION DESCRIPTION
ADDRESS(row_num, column_num, abs_num[, a1, Creates a reference to a specific cell.
sheet_text])
AREAS(reference) Finds the number of areas in reference.
CHOOSE(index_num, value1[, value2,...]) Selects a value from a list based upon the index value.
COLUMN(reference) Determines the column number for the reference.
COLUMNS(array) Finds the number of columns in an array.
GETPIVOTDATA(data_field, pivot_table[, field1, Allows you to capture specific data values from a
item1, field2, item2, ...]) PivotTable report.
HLOOKUP(lookup_value, table_array, row_index_num[, Finds the value in the specified row of the matching
range_lookup]) column.
HYPERLINK(link_location, [friendly_name]) Creates a shortcut to a document.
INDEX(reference[, row_num, column_num, Returns a reference to specified cells within
area_num]) reference.
INDIRECT(ref_text[, a1]) Returns a value or a reference to a value.
LOOKUP(lookup_value, array) Finds the specified value within an array.
MATCH(lookup_value,lookup_array[, match_type]) Locates a matching value in the array.
OFFSET(reference, rows, cols[, height, width]) Locates the range that is the specified number of
columns and rows from the referenced range.
ROW(reference) Determines the row number for the reference.
ROWS(array) Finds the number of rows in an array.
TRANSPOSE(array) Transposes the selected range from vertical to
horizontal, or vice versa.
VLOOKUP(lookup_value, table_array, col_index_num[, Finds the value in the specified column of the
range_lookup]) matching row.

248