Maybe:

=IF(AND(E$2=$B3,E$2<=$D3,BC31),BC3,0)

HTH
Jean-Guy


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=514574