multiple vlookups or find and replace or?

emily7

Hello,

I have a column with many rows each filled with different descriptions. I want to find words within the row and if a certain word is found then separate it out into different categories. The idea is similar to a vlookup in Excel, however, because there’s multiple words within each cell that matches, vlookup only return the first match.

For example:

Words	Category
Breakfast	a
Lunch	a
Dinner	a
social	b
party	b

Data	Amount	Category A	Category B
social bagel breakfast	$10	True	True
lunch break	$3	True	False
Team activity	$18	False	False

Thanks!

echuong1

I suggest separating out the values into a separate line, then doing the match.

This may not be the best way, but here's how I'd approach it.

New Workflow2.yxmd