SI.CUSTOMERNAME
Overview
The SI.CUSTOMERNAME function returns the customer name corresponding to one or more given customer IDs.
Syntax
CODE
=SI.CUSTOMERNAME(
ConnectionName,
CustomerId
)Arguments
The SI. CUSTOMERNAME function uses the following arguments:
Argument | Required/Optional | Description |
| Required | The name of the connection as configured in the Connection Manager |
| Required | The ID number(s) of the customer(s) |
Examples
Given the following configuration in Sage Intacct...
Example 1
CODE
=SI.CUSTOMERNAME(
"Sage",
"10001"
)Description
Returns the name of the customer with the ID "10001".
Result
Example 2
CODE
=SI.CUSTOMERNAME(
"Sage",
C2:C4
)Description
Returns the name of the customers whose ID numbers are listed in cell C2 through C4.
Result
Example 3
CODE
=SI.CUSTOMERNAME(
"Sage",
C2#
)Description
Returns the name of all customers whose ID numbers are displayed by the function in cell C2.
Result
