Here is the Data that i am trying to analyze:
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.
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)