Can Index Match pull multiple records?
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?
Tags:
Answers
-
I would suggest looking into a JOIN/COLLECT.
=JOIN(COLLECT({Contract Numbers}, {Customer}, "ABC"), "delimiter")
-
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?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!