Can Index Match pull multiple records?

Lexie Ozolnieks

I am trying to pull contract numbers from an Active Contract file over to a 2nd file using the customer name as the unique identifier which is working just fine via INDEX(MATCH), however, if a customer has more than 1 active contract it only pulls the first one over. What's the best way to pull all of the contract numbers associated with a specific customer?

Paul Newcome

I would suggest looking into a JOIN/COLLECT.

=JOIN(COLLECT({Contract Numbers}, {Customer}, "ABC"), "delimiter")

Lexie Ozolnieks

That worked perfectly, thanks! Now, however, I want to split the multiple contract numbers that I collected each onto their own cell (similiar to the text to columns in excel). Is this possible?