CONTAINS or other Function?

[slam]

I'm trying to determine if any of the text in H2 is a match for the entire contents of D2, and if it is, display Yes, else display No. The problem with this formula is that D2 is usually just text in quotes and not a cell reference, so I'm not sure if it can be modified, or if I should be using something else.

=IF(CONTAINS(H2,D2,TRUE),"Yes","No")

Any help would be greatly appreciated!

 

[Joe4]

Hi all, to clarify with an example:

D2: US36
H2: T1G.0191.51.8.5 (US03), 6300004210 (CH12), 6300004268 (CH05), 6300004212 (US36)

Result in this case should be "Yes" because "US36" is in H2.

Thanks.
That confirms what we thought, you are asking "does all of D2 exist anywhere in H2".
The formula vogateer gave you does exactly that, so you should be good!