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:
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.
Solved! Go to Solution.
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?