Formula/Conditional Formatting to Categories Data

[slthomp77]

Good afternoon! I am trying to find a solution to a work project. Currently, I have a list of items that I want to categorize into groups (see below.)

excel.JPG

I'll need to do this on a weekly basis (with new data, but the same item types/cateogories), and the groups will remain static. I don't care about counting the items or categories, I essentially just need to "tag" them into each of their respective groups. I'm sure there are a couple different ways to do this, and I am open to any/all. Thanks in advance!

[oeldere]

If I understand your question well, this can be done with Vlookup.