0

Maybe the title is a little confusing, but let me explain.

I have this table, where what I want is to check if any of the values of column Tools (D:D) are contained in Software (B2).

enter image description here

This would be the expected output, as "python" is contained in "Python 3.x", "netbeans" is contained in "Netbeans IDE" and so on.

enter image description here

So far, I've tried VLOOKUP, MATCH, and SEARCH, but I cannot make them work (I'm new in Excel, so I don't know much about formulas). Any ideas? I mean, if this is even possible.

Bryan Arreola
  • 197
  • 1
  • 6
  • 22
  • I am either profoundly oblivious and don't understand your question; or I am ProfoundlyOblivious and you need to edit your question because your expected output doesn't match your criteria. `"python" is contained in "Python 3.x", "netbeans" is contained in "Netbeans IDE" and so on` yet visual studio is no and it is contained in twice and Java is also no and it is contained once – ProfoundlyOblivious Jan 10 '20 at 04:09
  • ^ Agree that some of your output seems off - `visual studio` should be `Yes`, right? – BigBen Jan 10 '20 at 04:10
  • Yes, I need to edit the image, as the "Found" column was filled manually. I'm on it. – Bryan Arreola Jan 10 '20 at 04:13

1 Answers1

1

This is a classic case for COUNTIF and wildcards. In E2 and drag down:

=IF(COUNTIF(B:B,"*"&D2&"*")>0,"Yes","No")

EDIT:

Based on your revision, if you are trying to search for a match for B2 in D:D, you could do the following, which is the same approach as this question:

=IF(SUMPRODUCT(--ISNUMBER(SEARCH($D$2:$D$10,B2)))>0,"Yes","No")

enter image description here

BigBen
  • 46,229
  • 7
  • 24
  • 40
  • This is exactly what I asked, but vice versa, this one search `D2` value on `B:B`, but I need to search `B2` in `D:D`, I think I can make it work, you gave me the precise idea. – Bryan Arreola Jan 10 '20 at 04:24