Need Urgent Help with vlookup

Hi ..

How do you look up a value in a range..

eg : 1 to 2499 3.8%
2500 to 3499 4.0%
3500 to 4499 4.2%

so if someone puts in 2830 in the lookup table >> the answer shows up as 4.0%

Please give me an example vlookup formula and how the ascended order list should look like and how i am supposed to use it.

Thanks in advance

Hi
First you need to create your percentages table somewhere in your workbook, in the first column put your lookup value, in the second column put the corresponding percentages value. It should look like this:
1 3.8%
2500 4%
3500 4.2%

Now for ease of use I suggest you difine your table. Selecct the entire table then go to Insert/Name/Define and type a name for the table... i.e data

So lets say that the table is named "data" and your lookup value is in A1 you would put this formula in B1 or any other cell:
=VLOOKUP(A1,data,2,1)

Hope that helps!
JG