Return Multiple Look-up Values in a Contact List Field

We have a reference sheet which has a first column of Client ID followed by columns for Analyst Email and Manager Email (both are Contact List column type). On another sheet we have multiple columns and are trying to populate both the Analyst Email and the Manager Email values into one contact list field based upon the a Client ID look-up. Is this a nested vlook-up?

This formula is failing:

=VLOOKUP(VLOOKUP([Client ID #]2, {CSLS Teams by Account Range 1}, 4, false), {CSLS Teams by Account Range 1}, 6, false)

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Paul Newcome

Unfortunately the only way to populate multiple emails into a contact type column is manually. There is not a way to do it through a formula at this time. Feel free to Submit a Product Enhancement Request when you have a moment though.

Radu Antonie

Hi @Paul Newcome,

Was an enhancement done for this issue? Also, would a JOIN(COLLECT formula work in such instances now?

Thank you in advance for your answer.

Best,

Radu

Paul Newcome

@Radu Antonie Unfortunately it is still that you have to manually enter multiple contacts in a single cell to be able to use them as actual contacts.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.