Hi.

Your criteria for determining the returns effectively consists of an "OR" statement:

IF(($I$6>=$C$7:$C$3000)*($I$6<=$D$7:$D$3000)+($I$6=$E$7:$E$3000)+($I$6=$F$7:$F$3000)

which means that a row will be considered for return if any of the following three statements is true:

1) The value in column C is <= the value in I6 AND the value in column D is >= the value in I6

2) The value in column E is = the value in I6

3) The value in column F is = the value in I6

Since the value in I6 is currently blank, and there are also rows for which the column E (or F) entries are blank, there will be some rows which satisfy your conditions.

Regards