Help

Re: Find text from another cell

869 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Abraham_Bochner
8 - Airtable Astronomer
8 - Airtable Astronomer

I want to see if the text from one field contains in another cell

How will I do it?

Screenshot_25

I want to see if text from cell “ASIN1” contained in Cell “seller-sku”

2 Replies 2

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).

Screenshot 2020-01-23 at 18.16.35

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:

Screenshot 2020-01-23 at 18.22.15