Assistance with JOIN/INDEX and COLLECT function?

TheNickOdeh

Hey Community! What I'm looking to do:

I have Part Number and Key Supplier as 2 different columns. When I put in multiple part numbers (the first column), I want to return all of the associated suppliers (column 2).

Has anyone done this before?

L_123

=JOIN(COLLECT([Key Supplier]:[Key Supplier], [Part Number]:[Part Number], HAS([Part Numbers]@row, @cell)), ", ")

L_123

=JOIN(COLLECT([Key Supplier]:[Key Supplier], [Part Number]:[Part Number], HAS([Part Numbers]@row, @cell)), ", ")

TheNickOdeh

Amazing!! Thank you!