if e1 is between range b1 and c1 return d1
for e=23 should returns b
=IFERROR(INDEX($C$1:$C$6,MATCH(1,IF(D1>=$A$1:$A$6,
IF(D1<=$B$1:$B$6,1)),0)),"Not Found")
it doesn't work for 80?If E1 is 23 your formula returns b:
Excel 2010
A B C D E F 1 1 10 20 a 23 b 2 2 21 30 b 30 3 3 31 40 c 31 4 4 41 50 d 55 5 5 51 60 e 80 6 6 61 70 f 70
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>Sheet4
Worksheet Formulas
Cell Formula F1 =LOOKUP(E1,B1:B6,D1:D6)
<thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
it doesn't work for 80?
it returns not found for all of them