Formula to Look Up Multiple Contact Columns

chadedwardconway ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi There!

I am creating a formula that will assign contacts to a row based on user role plus some other attributes.

I am finding the look up is working great for assigning 1 contact, but when I extend the formula to include multiple v-look ups, its displaying the 2 users names as text. For example it will come back displayed as User1User2. The columns are set up to accept multiple contacts.

The formula I was trying is:

=VLOOKUP([Task Name]287, {Owners Range 1}, 4, false) + VLOOKUP([Task Name]288, {Owners Range 1}, 4, false)

Is there a particular delimiter i should use when adding multiple contacts to a cell using a formula?

Thank you!





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!