If Contains

smarterwithsmart · 11/03/23

I'm struggling with a formula to check a reference sheet for two conditions. An ID matching and a multi-select cell containing a certain value.

Here's the sheet with the desired results in the Has Blue column.

Here's the reference sheet.

DKazatsky2 · 11/03/23

Give this a try.

=IF(COUNTIFS({ID}, =ID@row, {Color}, HAS(@cell, "Blue")) > 0, "Yes", "No")

Hope this helps,

Dave

DKazatsky2 · 11/03/23

Give this a try.

=IF(COUNTIFS({ID}, =ID@row, {Color}, HAS(@cell, "Blue")) > 0, "Yes", "No")

Hope this helps,

Dave

smarterwithsmart · 11/04/23

Thank you very much, worked perfectly.

Best Answer