CODEWITHSUNDEEP
excel
Trunks80
Trunks80

Reputation: 13

Excel help - if keyword exists in a column for each row

I need help to check if a user has "Basic" in another column (Doesn't need to be same row) and return true in column D.

It seems I need to do some concatenation with index match but I do not know how to go about it. Can anyone help?

Col_A    Col_B    Co_C         Col_D
UserA    Data1    Basic        True
UserB    Data2    Premium      False
UserC    Data1    Basic        True
UserA     Data2   Classic      True

Upvotes: 1

Views: 55

Answers (1)

Mrig
Mrig

Reputation: 11712

Enter following formula in Cell D2

=IF(COUNTIFS($A$2:$A$5,A2,$C$2:$C$5,"Basic")>0,TRUE,FALSE)

or

=IF(SUMPRODUCT(($A$2:$A$5=A2)*($C$2:$C$5="Basic")),TRUE,FALSE)

Drag/Copy down as required. See image for reference.

enter image description here

Upvotes: 1

Related Questions