The following formula is in cell A10. Right now the formula returns data if the date in B5 matches with a date in column L on the Enter Executions worksheet. I would like to change the formula to return data if the dates in BOTH B5 and B6 match with a date in column L on the Enter Executions worksheet. Can anyone help?
=IFERROR(INDEX('Enter Executions'!A$2:A$100000,SMALL(IF(('Enter Executions'!$H$2:$H$100000=$B$4)+('Enter Executions'!$H$2:$H$100000=$B$4&" 2nd Leg"),IF('Enter Executions'!$L$2:$L$100000>=$B$5,IF('Enter Executions'!$L$2:$L$100000<$B$5+1,ROW('Enter Executions'!$B$2:$B$100000)-ROW('Enter Executions'!$B$2)+1))),ROWS($A$1:$A1))),"")
Bookmarks