Search code examples
excelexcel-formulafuzzy-searchvba

How can I do a keyword match from the content I am searching in Excel?

Here is the Data that i am trying to analyze:

enter image description here

As Shown in the picture, i am trying to match Column H with Column I. Any keyword match from Column H that matches in Column I would return a "1" and if no keyword matches it would return a "0".

I tried using Fuzzy Lookup, but am getting frustrated that it keeps giving me percentages and not a single 1 and 0. (true or false).

Is there anyway to do this with either a macro or equation or if someone could help me with Fuzzy Lookup too if that is a good solution as well.

Any help that could guide me in the right direction will help a lot. Thanks!

Edit: (10/27/17)

UPDATE:

I have used this users answer here: https://superuser.com/a/984389/464791

It is really useful. But it still lacks what i believe every single excel user/dev needs, which is a string comparison in the way i describe above. I am still looking for a solution mainly so i can learn and that others in the future could have one. As of right now i don't need this solution anymore. But it is still something i would like to work on.

Solution

  • Fuzzy Lookup is intended to return a percentile to reference how close of a match it is. Please refer here

    One option you could do is us the =IF() and have it display a 1 or 0 depending on how close of a match up it is.

    ie. =IF( D1 >= .50 , 1 , 0) or =IF( D1 <= .50 , 0 , 1)