Thanks it got me in the right direction and I figured it out!

"Bob Phillips" wrote:

=IF(F23="","",IF(F23<=$BT$6,$BZ$6,INDEX(BZ7:BZ11,M ATCH(1,(F23=BS7:BS11)*(F23<=BT7:BT11),0))))

which is an array formula, so enter with Ctrl-Shift-Enter.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Peter" wrote in message
...
=IF(F23<=$BT$6,$BZ$6,IF(AND(F23=$BS$7,F23<=$BT$7) ,$BZ$7,IF(AND(F23=$BS$8,F23<=$BT$8),$BZ$8,IF(AND( F23=$BS$9,F23<=$BT$9),$BZ$9,IF(AND(F23=$BS$10,F2 3<=$BT$10),$BZ$10,IF(AND(F23=$BS$11),$BZ$13,"0")) ))))
This is my formula, how do I make the cell read zero if there is no
information in f23