Help with IF / CONTAINS Function

monahana

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!

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")

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. 👍️