Excel Lookup and Reference Functions Syntax List

Last modified date

How to use Excel Lookup and Reference Functions Syntax List
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
1ADDRESSADDRESS(row_num,
column_num,
[abs-num],
[a1],[sheet_text])
2AREASAREAS(reference)
3CHOOSECHOOSE(index_num,
value1,
[value2],…..)
4COLUMNCOLUMN([reference])
5COLUMNSCOLUMNS(array)
6FIELDVALUEFIELDVALUE(value,
field_name)
7FORMULATEXTFORMULATEXT(reference)
8GETPIVOTDATAGETPIVOTDATA(data_field,
pivot_table,
[field1,item],……….)
9
HLOOKUPHLOOKUP(lookup_value,
table_array,row_index_num,
[range_lookup])
10HYPERLINKHYPERLINK(link_location,
[friendly_name])
11INDEXINDEX(array,row-num,
[column_num])
12INDEX INDEX(reference,row_num,
[column_num],
[area_num])
13INDIRECTINDIRECT(ref_text,[a1])
14LOOKUPLOOKUP(lookup_value,
lookup_vector,
[result_vector])
15LOOKUPLOOKUP(lookup_value,
array)
16MATCHMATCH(lokkup_value,
lookup_array,
[match_type])
17OFFSETOFFSET(refernce,
row,cols,[height],
[width])
18ROWROW([reference])
19 ROWSROWS(array)
20 RTDRTD(progID,server,
topic1,[topic2]………….)
21 TRANSPOSETRANSPOSE(array)
22 VLOOKUPVLOOKUP(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

1 Response

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment