Finding a Variable Value with in multiple ranges

I have a table and I'm having the hardest time trying to find a function that will allow me to enter in a value and have it return the points listed. So for example if I type in .25 in a cell I would like it to return 100. or if I typed 1.30 it should return 250.

I have tried VLookup but I obviously am not doing it correclty if that is the fuction that I need to use. Thanks for any help that I receive.

Min Max Points
0.00% 0.24% 50
0.25% 0.49% 100
0.50% 0.74% 150
0.75% 1.24% 200
1.25% 1.49% 250
1.50% 2.49% 300
2.50% 3.49% 340
3.50% 4.49% 380
4.50% 5.49% 420
5.50% 6.49% 460
6.50% 7.49% 500
7.50% 8.49% 530
8.50% 9.49% 560
>9.50% 600

Hi mikejohn11,

Welcome to the forum!!

Try this formula (currently set to work on a decimal value in cell B2 - change to suit):

=LOOKUP(B2,{0,0.25,0.5,0.75,1.25,1.5,2.5,3.5,4.5,5.5,6.5,7.5,8.5,9.5},{50,100,150,200,250,300,340,380,420,460,500,530,560,600})

Regards,

Robert

You're welcome