Mike, the correct formula should be:

=IF(AND(E3=B3,E3<C3),D3,IF(AND(E3=B4,E3<C4),D4,I F(AND(E3=B5,E3<C5),D5,IF(AND(E3=B6,E3<C6),D6,"") )))

the references a

E3=Value to check
B3=1
C3=10
D3=A

B4=10
C4=20
E4=B

B5=20
C5=30
D5=C

B6=30
C6=40
D6=D

Formula is placed in cell F3. It is always comparing that the value to
be verified must be grater than or equal than the first value and less
than the second value.
Let me know if that solves the problem.

best regards.

Juan Carlos


+-------------------------------------------------------------------+
|Filename: SampleSpreadsheet.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3455 |
+-------------------------------------------------------------------+

--
cscorp
------------------------------------------------------------------------
cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015
View this thread: http://www.excelforum.com/showthread...hreadid=188515