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])