=VLOOKUP(101,A2:D6,3,1)
or
=SUMPRODUCT(--(A2:A6=101),--(B2:B6<=225),C2:C6)


"JerryS" wrote:

Using the following table, I want a formula that satifies multiple IF type
statements.

From To MTM Renew 10
0 30 $32.39 $17.60
31 100 $31.94 $15.35
101 225 $31.04 $14.00
226 450 $30.59 $12.20
451 1000 $29.24 $10.40

For example, if one value is greater than 101 and less than 225, the value
is $31.04.

Any ideas?

--
JerryS