SI.VENDORNAME

Overview

The SI.VENDORNAME function returns the vendor name corresponding to one or more given vendor IDs.

CODE

=SI.VENDORNAME(
    ConnectionName, 
    VendorID
)

The SI. VENDORNAME function uses the following arguments:

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`VendorID`	Required	The ID number of the vendor

CODE

=SI.VENDORNAME(
    "Sage", 
    "20001"
)

Description

Returns the name of the vendor with the ID "20001".

Result

CODE

=SI.VENDORNAME(
    "Sage", 
    C2:C4
)

Description

Returns the name of the vendors whose ID numbers are listed in cell C2 through C4.

Result

CODE

=SI.VENDORNAME(
    "Sage", 
    C2#
)

Description

Returns the name of all vendors whose ID numbers are displayed by the function in cell C2.

Result