I have a prospect list of various companies in our area and I am trying to categorize them by their annual revenue. Based on the companies annual revenue value, I want to put a formula in an adjacent cell that will label thje revenue value as one of the following:

$1 - $5MM
$5 - $10MM
$10 - $25MM
$25 - 50MM
I have this set up on another sheet (see below), but am trying to figure out how to make a formula that will make use of this table. I'm thinking something along the lines of a VLOOKUP funciton, but it has to be more complex than that.
Revenue Threshold Category
1 $1 - $5MM
5 $5 - $10MM
10 $10 - $25MM
25 $25 - 50MM
50