Joining two columns together for rows that match criteria

Hello,

I have a sheet with many columns from which I want to pull [Data]2 and [Data]20, in this format: "Data2 (Data20), Data2 (Data20),..." from another sheet.

So far we have

=IF(ISBLANK([Source1]@row), "", JOIN(COLLECT({Data2}, {Data5}, CONTAINS([Source1]@row, @cell), {Major/Minor}, "Major"), ", "))

And get

Data2, Data2, Data2, ...

but we have no way to add the second part. Any solutions?

Appreciate any help! We are stumped on our end :)

Find more posts tagged with

Formulas

Automations

Conditional Formatting

Cell linking

Accepted answers

All comments

Paul Newcome

You would need to combine them in each row on the individual sheets and then pull them into this sheet.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.