software

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

Forget. Two seconds after posting I figured it out.

quot;Carpiequot; wrote:

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

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,quot;*quot;amp;B2amp;quot;*quot;)gt;0,A1,quot;quot;)

Does that help?
--
Regards,
Davequot;Carpiequot; wrote:

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