lookup formula?

[Guest]

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?

 

[Guest]

try,

=if(and(c1>b1,c1<b2),a1,false)

hth
regards from Brazil
Marcelo

"Kfry57" escreveu: