If B2 = anything in column C, add A1

C

Carpie

What would the proper function for this be? I thought I could use sumproduct
but I'm not getting what I expected.
 
D

David Billigmeier

I think this is what you want.... This function will output the value in A1
if the value in B2 appears in ANY text string in column C.

=IF(COUNTIF(C:C,"*"&B2&"*")>0,A1,"")

Does that help?
 
Top