Here's an example of what I'm trying to accomplish with a formula:

A B C D E
1 33789 4 26001 28000 1
2 23000 ERROR 28001 30000 2
3 27999 1 30001 32000 3
4 32001 34000 4
5 34001 36000 5

Columns C, D, & E are fixed values. User would input an amount into A1 and then B1 would populate based on the value compared to columns C, D, & E.

What I need to say, but just not sure how is:
IF A1 > C1 BUT < D1 THEN B1=E1 ELSE IF A1 > C2 BUT < D2 THEN B1=E2 ELSE IF A1 > C3 BUT < D3 THEN B1=E3 etc etc etc

I have about 27 rows (of "ranges") that I need to compare that number to - so I figured there has to be an easier way than having a formula that's a mile long...any suggestions??

Thank you SO much!
Michelle