I want to see if the text from one field contains in another cell
How will I do it?
I want to see if text from cell “ASIN1” contained in Cell “seller-sku”
Hi @Abraham_Bochner - you can do this with a FIND formula:
IF(
AND(asin1, {seller-sku}),
IF(FIND(asin1, {seller-sku}) > 0, 'present', 'not present')
)
(with the AND, I’m just checking that both values are present before I do the evaluation).
JB
If letter case is not important you can also lower case both sides before the doing the FIND:
IF(
AND(asin1, {seller-sku}),
IF(FIND(LOWER(asin1), LOWER({seller-sku})) > 0, 'present', 'not present')
)
then it will match if case is ignored:
