VLOOKUP with conditional table array

[djh30]

I want to do a vlookup with an item that could fall in a couple different ranges of numbers.

Under $50,000 2.00%
$50,000-$200,000 2.10%
$200,001-$400,000 2.20%
$400,001-$600,000 2.30%
$600,001 -$800,000 2.40%
$800,001-$1,000,000 2.50%
$1,000,001-$1,200,000 2.60%


So if the input is 56,000 I want the VLOOKUP to give me 2.10%
If the input is 850,000, I want the VLOOKUP to give me 2.5%

Does anyone know how to do this? I've attached a spreadsheet with the exact scenario.
Book2.xlsx
Thanks for the help in advance!

[daddylonglegs]

If you create a column with the lower bound of each range then you can use LOOKUP like this

=LOOKUP(H2,C$3:D$29)*H2

see attached