Hi, I'm trying to find a formula to check whether any search terms in Col A (which would be separated by spaces), are contained in in Col B (words also separated by spaces), and put a "yes" or "no" in Col C
In the example below, Col A is the data to be cleaned up, Col B is the Categories to be searched, & Col C = "are any words in Col A contained in Col B".
I've tried all sorts of helper columns and FIND and SEARCHES, but I'm wondering if there is a better way with a single formula!?
<tbody>
</tbody>
In the example below, Col A is the data to be cleaned up, Col B is the Categories to be searched, & Col C = "are any words in Col A contained in Col B".
I've tried all sorts of helper columns and FIND and SEARCHES, but I'm wondering if there is a better way with a single formula!?
Col A: Data To be Cleaned | Col B: Categories | Any words from Col A contained in Col B? |
ball and socket | balls, joints, bearings | yes |
belt on car | belting | yes |
tube for valve | pipe and tube | yes |
regulators, valves | adapters | no |
air cond'g pipe | pipes and exhausts | yes |
<tbody>
</tbody>