Hi there! I have a bit of a complicated problem to solve and not sure how to approach it.
What I need to do is search the URL Column to see if any of the URLs contain all of the words from the Text column cell. In the example above the equation should recognize that the text in Column 2 row 2 has all the words for Column 3 Row 4 and then it should grab the URL and put it into the first column.
Thank you in advance
Equation Goes Here | Text | URL | |
Matching URL value if all words found. In this case it would be the value from Column 3 Row 4. |
| URL String | |
Text Value | URL String | ||
Text Value | |||
Text Value | URL String |
What I need to do is search the URL Column to see if any of the URLs contain all of the words from the Text column cell. In the example above the equation should recognize that the text in Column 2 row 2 has all the words for Column 3 Row 4 and then it should grab the URL and put it into the first column.
Thank you in advance