The ADDRESS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ADDRESS function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the ADDRESS function in Microsoft Excel is:
ADDRESS( row, column, [ref_type], [ref_style], [sheet_name] )
2)AREAS function
The AREAS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the AREAS function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the AREAS function in Microsoft Excel is:
AREAS( reference )
3)CHOOSE function
The CHOOSE function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the CHOOSE function can be entered as part of a formula in a cell of a worksheet. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.
Syntax
The syntax for the CHOOSE function in Microsoft Excel is:
CHOOSE( position, value1, [value2, ... value_n] )
4)COLUMN function
The COLUMN function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the COLUMN function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the COLUMN function in Microsoft Excel is:
COLUMN( [reference] )
5)COLUMNS function
The COLUMNS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the COLUMNS function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the COLUMNS function in Microsoft Excel is:
COLUMNS( reference )
6)HLOOKUP function
The HLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the HLOOKUP function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the HLOOKUP function in Microsoft Excel is:
HLOOKUP( value, table, index_number, [approximate_match] )
7)HYPERLINK function
The HYPERLINK function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the HYPERLINK function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the HYPERLINK function in Microsoft Excel is:
HYPERLINK ( link, [display_name] )
8)INDEX function
The INDEX function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the INDEX function can be entered as part of a formula in a cell of a worksheet.
The INDEX function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the INDEX function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the INDEX function in Microsoft Excel is:
INDEX( table, row_number, column_number )
9)INDIRECT function
he INDIRECT function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the INDIRECT function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the INDIRECT function in Microsoft Excel is:
INDIRECT( string_reference, [ref_style] )
10)LOOKUP function
The LOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the LOOKUP function can be entered as part of a formula in a cell of a worksheet.
There are 2 different syntaxes for the LOOKUP function:
LOOKUP Function (Syntax #1)
In Syntax #1, the LOOKUP function searches for value in the lookup_range and returns the value in the result_range that is in the same position.
The syntax for the LOOKUP function in Microsoft Excel is:
LOOKUP( value, lookup_range, [result_range] )
11)MATCH function
The MATCH function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the MATCH function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the MATCH function in Microsoft Excel is:
MATCH( value, array, [match_type] )
12)OFFSET function
The OFFSET function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the OFFSET function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the OFFSET function in Microsoft Excel is:
OFFSET( range, rows, columns, [height], [width] )
13)ROW function
The ROW function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ROW function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the ROW function in Microsoft Excel is:
ROW( [reference] )
14)ROWS function
The ROWS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ROWS function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the ROWS function in Microsoft Excel is:
ROWS ( reference )
15)SWITCH function
The SWITCH function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a VBA function (VBA) in Excel. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.
Syntax
The syntax for the SWITCH function in Microsoft Excel is:
Switch ( expression1, value1, expression2, value2, ... expression_n, value_n )
16)TRANSPOSE function
The TRANSPOSE function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the TRANSPOSE function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the TRANSPOSE function in Microsoft Excel is:
TRANSPOSE( range )
17)VLOOKUP function
The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet.
The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the VLOOKUP function in Microsoft Excel is:
VLOOKUP( value, table, index_number, [approximate_match] )
18)ASC function
The ASC function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a VBA function (VBA) in Excel. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.
Syntax
The syntax for the ASC function in Microsoft Excel is:
Asc( string )
19)CHAR function
The CHAR function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the CHAR function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the CHAR function in Microsoft Excel is:
CHAR( ascii_value )
20)CHR function
The CHR function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a VBA function (VBA) in Excel. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.
Syntax
The syntax for the CHR function in Microsoft Excel is:
Chr( ascii_value )
No comments:
Post a Comment