the lookup formulas were originally designed to work with
tax tables (I think) anyway, if you take the ,false out of
the formula, =vlookup(A1,Range,2) then the formula will
look for the closest match without going over.

0 xxx
10 yyy
20 zzz

=vlookup(5,range,2) will result in xxx. Make sure your
lookup column (0,10,20) is sorted from lowest to highest.

-----Original Message-----
I'm trying to develop a formula to extract info from a
table. The vertical column is a range that corresponds to
a calculation in the table body. I must have a
calculated
number be able to pick the correct range and then the
lookup functions would be able to pick the associated
formula.

E.g. if cell A1 = 15.3, I have a column such as:

0 - 10 xxx
10.01 - 15 xxx
15.01 - 20 xxx
where xxx is the formula.
How can I get it to pick the third row formula without a
nest of if statements (I have many lines)?

Thanks.
.