First add a helper column next to the last columnn in Sheet 2,

Assuming that your first row contains column titles and the table is current in A1:C1000, then in the first cell of row 2, enter:

Code:

`=IF(AND(B2<=TODAY(),C2>=TODAY()),"Ok","")`

, copy that down (you can hide this column if desired).

Then in sheet 1, Cell A2, enter:

Code:

`=IF(ROW(Sheet2!$D2)-ROW(Sheet2!$D$1)>COUNTIF(Sheet2!$D$1:$D$1000,"Ok"),"",INDEX(Sheet2!A$1:A$1000,SMALL(IF(Sheet2!$D$1:$D$1000="Ok",ROW(Sheet2!$D$1:$D$1000)),ROW(Sheet2!$D2)-ROW(Sheet2!$D$1))))`

Remember, to adjust ranges to suit (i.e. replace 1000, with the number of records you have)

Confirm this formula with Ctrl+Shift+Enter, not just Enter and then copy it down as far as your list in Sheet2 is long.

These formulas will self adjust according to current date.

Note: If you want to also pull the corresponding start and end dates, then just copy the big formula over to the next columns. You may have to format those date columns as Date.