I need help trying to return a value based on 2 conditions.

Based on the table below i need a formula to return the value where the Category (A,B,C,D) meet the percentage.

Eg if % is 5% (between 0% and 10%) and is a Catergory C then i want to return the value 1.0.

Think that this is quite an easy function however i just cannot get my head round it.

Appreciate any help on this.


--------------------- A - B - C - D
between 0% 10% 0.5 0.8 1.0 1.3
between 11% 20% 1.0 1.3 1.5 1.8
between 21% 30% 1.5 1.8 2.0 2.3
between 31% 100% 2.0 2.3 2.5 2.8