Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to find if contents of cell contains contents of another cell in different table

Solved
Jump to Solution
362 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Happy to do the following in both Airtable and Excel (and involving as many steps as necessary). I have two separate tables with a similar multiselect column in each, involving many values or “tags” as I call them:

Table 1:
image

Table 2:
image

I want to add an additional column in Table 1 titled “Tags”. I’m trying to populate this column.

If Table 2’s Product Tags can all be found in Table 1’s Product Tags (not an exact match, but rather if Table 1’s column contains the content from Table 2), then I would like to return the name of the brand (column A) from Table 2.

Please help!!

1 Solution

Accepted Solutions

Hi @Annie_Li,

Adam from Airtable here. To implement this in your base I think you’ll want to employ the use of linked record fields that allow you to use lookup, rollup, and count fields.

More here: Screen Recording 2021-05-13...

Hope that helps point you in the right direction~~

See Solution in Thread

3 Replies 3

Hi @Annie_Li,

Adam from Airtable here. To implement this in your base I think you’ll want to employ the use of linked record fields that allow you to use lookup, rollup, and count fields.

More here: Screen Recording 2021-05-13...

Hope that helps point you in the right direction~~

I love the video, thank you!

I have a follow up question. I’ve done what you’ve recommended, and now I have two columns with matching brands. Is there a way I can fill a third column with matching values from the two columns for each row (“Similar brands based on products” and “Similar brands based on feel”)?

Otherwise I suppose I need to manipulate it in a database and paste it back here?

image