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