Hi,
First of all, I sincerely apologise if it is not a macro-related problem.
So I got sets of values in two text values in column A and column B.
What I am trying to do is to have column C say "yes" or "No" based on a test that sees if cell A1's value is in a cell in column B but at the same time, that cell's value was present in A2. I apologise, I know it is not the best way to explain it, but I am unable to find the words. Hence, I drew the table.
Basically, I want to know if 'blue lion' is asking for 'purple king' only if 'purple king' is also asking for 'blue lion'. I have around 20,000 items like this, with long text strings in column B, whereas the text in column A is much shorter, like 3 words to 10 words long maximum.
Thanks in advance, and I apologise for my poor explanation of the problem.
Blue lion helicopter; purple king Yes purple king blue lion; airplane Yes red devil helicopter; purple king No
Bookmarks