Thread: 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

try,

=if(and(c1>b1,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