Lookup & Reference Functions
Excel Lookup and Reference functions help you to work with arrays of data, and are particularly useful when you need to cross reference between different data sets. Please clink in "Example" to see full description of the function, with examples of use and details of common errors.
| Functions |
Syntax |
Tutorial |
| ROW Function |
ROW(reference) |
Example |
| ROWS Function |
ROWS(array) |
Example |
| COLUMN Function |
COLUMN(reference) |
Example |
| COLUMNS Function |
COLUMNS(array) |
Example |
| INDIRECT Function |
INDIRECT(ref_text,C1) |
Example |
| VLOOKUP Function |
VLOOKUP(lookup_value,table_array, col_index_num, range_lookup) |
Example |
| HLOOKUP Function |
HLOOKUP(lookup_value, table_array, row_index_num, range_lookup) |
Example |
| INDEX Function |
INDEX(array,row_num, column_num) |
Example |
| MATCH Function |
MATCH(lookup_value, lookup_array, match_type) |
Example |
| Excel OFFSET Function |
OFFSET(reference, row, cols, [height], [width]) |
Example |