Determine if items in multi-select dropdown match items in another list

I have a sheet 1 with a multi-select dropdown, eg, multiple names in one cell. I have another list of target names on a separate sheet 2, and I want to check which rows in sheet 1 contain the names on sheet 2, and how many names match in each row. So for example, if row 1 of sheet 1 contained the Names cell: Bob, Doug, Pete, and sheet 2 contained the list of names: Amy, Bob, Claire, Doug, Ed, Frank, George, Harriet, Irv, June - I would want to flag row 1 of sheet 1 with a "2" indicating 2 names in the Names cell matched the names from Sheet 2.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!