Help with IF / CONTAINS Function

Hi!

I am trying to write a formula that will look at a description column, see if it contains a specific string of text, then return a list of adjacent cells where the formula is true.

Said another way, I want to type a string into a cell (A1), look at the description column on another sheet, then return a list in column B of reference numbers that are adjacent to the cells that contain the string from A1.

Any help would be greatly appreciated!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would need to use a JOIN/COLLECT.

=JOIN(COLLECT({Sheet B Adjacent Column}, {Sheet B A1 Column}, CONTAINS(A1, @cell)), "delimiter_of_choice")

All comments

Paul Newcome

You would need to use a JOIN/COLLECT.

=JOIN(COLLECT({Sheet B Adjacent Column}, {Sheet B A1 Column}, CONTAINS(A1, @cell)), "delimiter_of_choice")

monahana

That worked perfectly, thanks!

Paul Newcome

Happy to help. 👍️

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.