I need a foumla to do the following.

Look at column C and determine if it is between the ranges in column M and
column N, and then i need it to look at column AB and determine if the info
in column AB is between the ranges in column O and P. Once these two are
determined i need it to return the corresponing value in column Q.

ANY IDEAS?
HERE IS WHAT MY TABLE LOOKS LIKE

M N O P Q
$0.00 $1,499,999.99 0 1.99
0.10%
$0.00 $1,499,999.99 2 2.99
0.20%
$0.00 $1,499,999.99 3 3.99
0.40%
$0.00 $1,499,999.99 4 4.99
0.65%
$0.00 $1,499,999.99 5 100 0.80%
$1,500,000.00 $1,999,999.99 0 1.99 0.10%
$1,500,000.00 $1,999,999.99 2 2.99 0.25%
$1,500,000.00 $1,999,999.99 3 3.99 0.55%
$1,500,000.00 $1,999,999.99 4 4.99 0.85%
$1,500,000.00 $1,999,999.99 5 100 1.00%
$2,000,000.00 $2,999,999.99 0 1.99 0.15%
$2,000,000.00 $2,999,999.99 2 2.99 0.30%
$2,000,000.00 $2,999,999.99 3 3.99 0.70%
$2,000,000.00 $2,999,999.99 4 4.99 1.00%
$2,000,000.00 $2,999,999.99 5 100 1.20%
$3,000,000.00 $3,999,999.99 0 1.99 0.15%
$3,000,000.00 $3,999,999.99 2 2.99 0.35%
$3,000,000.00 $3,999,999.99 3 3.99 0.80%
$3,000,000.00 $3,999,999.99 4 4.99 1.20%
$3,000,000.00 $3,999,999.99 5 100 1.30%
$4,000,000.00 $5,999,999.99 0 1.99 0.20%
$4,000,000.00 $5,999,999.99 2 2.99 0.40%
$4,000,000.00 $5,999,999.99 3 3.99 0.90%
$4,000,000.00 $5,999,999.99 4 4.99 1.35%
$4,000,000.00 $5,999,999.99 5 100 1.55%
$6,000,000.00 $1,000,000,000.00 0 1.99 0.20%
$6,000,000.00 $1,000,000,000.00 2 2.99 0.40%
$6,000,000.00 $1,000,000,000.00 3 3.99 1.00%
$6,000,000.00 $1,000,000,000.00 4 4.99 1.50%
$6,000,000.00 $1,000,000,000.00 5 100 1.70%