Excel 2007 : conditional selection of percentage

Please can some one help me solve this problem, it is probably simple but its driving me crazy



95 to 99.9.....33%
100 to 104.9........34%
105 to 109.9 .......34.5%
110 to 114.9.......35%
115 to 119.9 ........35.5%

I want to select a percentage to use based on where the value in a cell falls between the bands of numbers in the above table

so if my weekly price was 102 I want to auto select 34% for the calculation I'm going to perform

I will be very grateful for any help solving this

Cheers

Steve

=Lookup(A1,{0,95,100,105,110,115,120},{0,.33,.34,.345,.35,.355,0})

where A1 contains the input

Note, I assigned 0 to less than 95 and greater than 119.9.. you can adjust.