Match single word to string of text

Hi,

I have a multiple items split into groups, and each group has a number assigned to it ("Groups" tab in attached workbook).

I also have a list of items in the "List" tab. All of these items come from one of the groups in the "Groups" tab.

What I need is to match the items in the "List" tab to corresponding group number in which the item is in on the other tab - the "List" tab shows what the end result should look like. The items can appear multiple times, and more than one item from the same group can also appear.

Is this even possible?

Thanks, that worked!

So you're using wildcards to match, just for my understanding of the formula?

Double post

Awesome, thanks!