Find text from another cell

[Abraham_Bochner]

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”

[JonathanBowen]

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

[JonathanBowen]

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: