Multiple lookup

[saechaoc]

So I'm comparing data from two databases and I have to cross check data.
I have multiple product lines for a supplier ID so 123 has 15 products ie. 123 is associated with Deoderant, Waterbottle etc. How do I match all of these? I need to pull that list of values.

Sorry if thats not very descriptive but consider
A1 = Supplier ID
B1 = Product

C1: Supplier ID (from database)
D1: product (from database)

[saechaoc]

Used a index array to figure it out. No need for a solution!