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

--
Don Guillett
SalesAid Software

"Lindsay" wrote in message
...
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.