Excel Lookup and Reference Functions Syntax List

Below the list of Excel Lookup and Reference Functions, at bottom of the table links are provided to download this data in PDF and Excel Formats.
S.no. | Function Name | Syntax |
1 | ADDRESS | ADDRESS(row_num, column_num, [abs-num], [a1],[sheet_text]) |
2 | AREAS | AREAS(reference) |
3 | CHOOSE | CHOOSE(index_num, value1, [value2],…..) |
4 | COLUMN | COLUMN([reference]) |
5 | COLUMNS | COLUMNS(array) |
6 | FIELDVALUE | FIELDVALUE(value, field_name) |
7 | FORMULATEXT | FORMULATEXT(reference) |
8 | GETPIVOTDATA | GETPIVOTDATA(data_field, pivot_table, [field1,item],……….) |
9 | HLOOKUP | HLOOKUP(lookup_value, table_array,row_index_num, [range_lookup]) |
10 | HYPERLINK | HYPERLINK(link_location, [friendly_name]) |
11 | INDEX | INDEX(array,row-num, [column_num]) |
12 | INDEX | INDEX(reference,row_num, [column_num], [area_num]) |
13 | INDIRECT | INDIRECT(ref_text,[a1]) |
14 | LOOKUP | LOOKUP(lookup_value, lookup_vector, [result_vector]) |
15 | LOOKUP | LOOKUP(lookup_value, array) |
16 | MATCH | MATCH(lokkup_value, lookup_array, [match_type]) |
17 | OFFSET | OFFSET(refernce, row,cols,[height], [width]) |
18 | ROW | ROW([reference]) |
19 | ROWS | ROWS(array) |
20 | RTD | RTD(progID,server, topic1,[topic2]………….) |
21 | TRANSPOSE | TRANSPOSE(array) |
22 | VLOOKUP | VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) |
Click here to download the Excel Lookup and Reference Functions Syntax List in PDF format
Click here to download the Excel Lookup and Reference Functions Syntax List in Excel Workbook
Excellent.. Very useful