Two Formulas

[Guest]

Is there a lookup formula that looks up a table then brings back a value if
it is between that range. For example, Age range 21-25 = $10.00. I want to
look find how much age 23 is, but I don't want to input 21,22,23,24,25 =
$10.00 in the table.

Also, I need to lookup an x and y value and bring back a value. For example,
age on y axis and amount of coverage on x axis bring back value when they
meet.

 

[Don Guillett]

have a look at IF and AND
=if(and(ag>=21,ag<=25),10,0)