Creating a Bucket List

Hello All,

I need some help with a formula/function to put a set of values into a bucket, depending upon the value.

I've attached a spreadsheet with sample data for your review.

I'm looking to put the Ranking # into one of several Ranking Buckets based on the criteria below:

1-399
400-449
0, 450-499
500-549
550-599
600-649
650-699
700+

I've tried using a LOOKUP function, but I think I'm missing something with it.
=LOOKUP(C2,{1-399,449,499,549,599,649,650,700},{"1-399","400-449","450-499","500-549","550-599","600-649","650-699","700+"})

Thank you all!
Jen

Excel Bucket.xlsx

Is it possible to group the 0's in with the 450-499 range?

Perfect, thank you very much, I appreciate it!