
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