Assuming I understand the availability of this function, this looks like a job for the TEXTJOIN() function: https://support.office.com/en-us/art...3-0e8fc845691c coupled with a lookup function https://support.office.com/en-us/art...8-93a18ad188a1