lookup formula?
 

I have the following (Col A & B is a Table);

A B C D
1 30 31 (Formula Result)
2 32 34 (Formula Result)

C1 is larger than b1 but smaller than b2 so the result is A1 or 1.

Is there a formula that can do this for me?
--
Kfry57

lookup formula?
 

try,

=if(and(c1b1,c1<b2),a1,false)

hth
regards from Brazil
Marcelo

"Kfry57" escreveu:

I have the following (Col A & B is a Table);

A B C D
1 30 31 (Formula Result)
2 32 34 (Formula Result)

C1 is larger than b1 but smaller than b2 so the result is A1 or 1.

Is there a formula that can do this for me?
--
Kfry57