Returning multiple values if a cells value falls in a range of values.

I've come at this a few ways and thought maybe someone would have some insight on a better way. Basically if an item's(A) sales(B) fall between a minimum and maximum range I need it to return values for Par(C), Roq(D), and WH(E).
My initial though was to create a spreadsheet with each possible value I'd be working with, for example instead of a min-max of 1-5 I would create five lines of data for 1,2,3,4,5. I could still do this to get it to functions but I'd rather not have to keep this sheet attached with that information. I thought I could potentially hide it in a macro but I'm not having much luck with how to accomplish it.
How would you go about accomplishing this task? Any help/thoughts are appreciated. I've attached a workbook as an example.

I noticed some unexpected values were returned. For Coke 4,6,3 rather than 4,7,4 and for sprite, 6,10,5 rather than 6,11,6. Thanks for the reply, and thoughts on why this happened?