Vlookup Help

I'm new to Vlookup's so i need a bit of help, to be honest i'm not sure i'm using the correct function.

I have a spreadsheet(attached, not the full sheet). I have a list of 4 products, then quantities, then this is where i've been trying to use Vlookup. This column will change depending on the previous column.

The problem is as you will see from my sheet i have a range of figures i.e 1 -29,999 =10% , 30,000 -59,999 = 6.5% each with there own %.

So if i have 25,000 in C column D should change to 10%.

Can i use Vlookup for this.

Thanks