There are a couple ways to categorize your values: with if or vlookup. Download the spreadsheet and practice along with me.
If you choose to download these materials, you'll be added to my mailing list. You can unsubscribe at any time, but I hope you'll stick around. I share data tricks every week or so.