Hi,

I am attempting to cross-reference contacts with multiple contacts from a helper sheet to the Vendor II column pictured below. I have three different "Businesses" and eight different "Markets" and specific contacts align to each "Business/Market".

Example:

LTSS and New York: Specific Contacts

LTSS and Nevada: Specific Contacts

HBMC and New York: Specific Contacts

Attempted Formulas:

#UNPARSEABLE

=INDEX(COLLECT({Vendor Contact Production Range 1}, Business@row, {Vendor Contact Production Range 2}, Market@row, {Vendor Contact Production Range 3}, 1)))

=IFERROR(INDEX(COLLECT({Vendor Contact Production Range 1}, Business@row, {Vendor Contact Production Range 2}, Market@row, {Vendor Contact Production Range 3}, 0))"")

=JOIN(COLLECT({Vendor Contact Production Range 1}, Business@row, {Vendor Contact Production Range 2}, Market@row, {Vendor Contact Production Range 3}, 1)")")

#INCORRECT ARGUMENT SET

=IFERROR(INDEX(COLLECT({Vendor Contact Production Range 1}, Business@row, {Vendor Contact Production Range 2}, Market@row, {Vendor Contact Production Range 3}, 1)))

The Vendor Contact column shown below is incorrect as it is solely based on the "Market" without considering the specific business. Any guidance is appreciated.