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?
Help Article Resources
Check out the Formula Handbook template!