Overview
The SI.ITEMNAME function returns the item name corresponding to one or more given item IDs.
Syntax
=SI.ITEMNAME(
ConnectionName,
ItemID
)
Arguments
The SI. ITEMNAME function uses the following arguments:
|
Argument |
Required/Optional |
Description |
|
|
Optional |
Provide one of the following values:
OR Omit the argument to return results for all compatible connections with default aggregation settings. |
|
|
Required |
The ID number(s) of the item(s) |
Examples
Assuming the following configuration within Sage Intacct:
Example 1
=SI.ITEMNAME(
"Sage",
"1001"
)
Description
Returns the name of the item with the ID "1001".
Result
Example 2
=SI.ITEMNAME(
"Sage",
C2:C4
)
Description
Returns the name of the items whose ID numbers are listed in cell C2 through C4.
Result
Example 3
=SI.ITEMNAME(
"Sage",
C2#
)
Description
Returns the name of all item names whose ID numbers are displayed by the function in cell C2.
Result
