![Abraham_Bochner Abraham_Bochner](https://community.airtable.com/legacyfs/online/avatars/3X/0/b/0b5e902b1124944e0e11ef4e2b892f2888576ed9.jpeg)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 23, 2020 08:40 AM
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”
2 Replies 2
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 23, 2020 10:20 AM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 23, 2020 10:22 AM
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:
![](/skins/images/C00E88548E36A45C286684DFDAE5323C/responsive_peak/images/icon_anonymous_message.png)