Hi Guys,
Is there a way where two cells can be matched on containing some of the same text? I have been using ISNUMBER(SEARCH()) to match but this only matches the whole string.
See the below example:
<tbody>
AMCO
Amco Services
TRUE
</tbody>
using the ISNUMBER(SEARCH()) function will match...