SI.ACCOUNTNAME

Overview

The SI.ACCOUNTNAME function returns the account name corresponding to a given account code.

CODE

=SI.ACCOUNTNAME(
    ConnectionName, 
    Account
)

The SI. ACCOUNTNAME function uses the following arguments:

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`Account`	Required	The code of the account

CODE

=SI.ACCOUNTNAME(
    "Demo", 
    "10010"
)

Description

Returns the name of the account with the code "10010".

Result

Referencing a specific account:

Referencing a cell containing an account:

Referencing multiple accounts displayed as an Excel array: