Find text from another cell

+17

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”

This topic has been closed for replies.

+18

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

+18

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:

Sign up