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