Okay very simple problem here. I have a unit sold volume that changes. When said volume changes, as does the price. We have 5 pricing brackets.

0-59 $1000 ea
60-119 $2000 ea
120-179 $3000 ea
180-399 $4000 ea
400-999 $5000 ea

I have one cell that changes in unit volume and I want the adjacent cell to spit out the corresponding price. Based on the pricing matrix above, what is the formula that identifies the one changing unit volume cell and kicks out it's correct price?

Thank you in advance