Find a Match withing a Join?


How can I use MATCH to find if an instance occurs within a group of values joined with JOIN?

For example, if I join the values in three columns (Red Yellow Blue), no commas just a space, and I want to MATCH the value in a cell (say, "Red"), how can I see if the joined values (Red Yellow Blue) contains Red?

Right now, the result is no match, because the cell is not a perfect match. 

I thought about finding a way to match the value in a cell (say, "Red") across three columns (rather than adding a helper column that joins the three values into a single column, but then I increase my reference cells. So, I though joining the values into a single cell would help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!