Thread: Two Formulas
View Single Post
  #1   Report Post  
Lindsay
 
Posts: n/a
Default Two Formulas

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.