Show date greater than today on schedule

[ulak]

Best,

I have an employee roster where I want to have dates filled in for a specific shift based on another sheet. Now Vlookup shows the first best match, however, the idea is that based on today's date these dates are filled in. In short:

The particular person's schedule should be shown compared to today's date. Can you help me with this?

I hope my question is clear.

Main schedule

Second schedule.

The values in start and end must be entered on the main schedule.

I tried Vlookup, no succes. I tried Index and Match, no succes. I think if I can doe aan greather then check in the Index formula that I will receive the resultst I wish, but I do not have enough experience with that.

 

[Special-K99]

I wish people would put cell references in their screenshots, otherwise it makes any formula solution pretty useless.
I'm assuming the following

the top left hand corner of each screenshot is A1 (otherwise adjust the cell references in the formula)

Array formula

=IF(ISNA(MATCH($A6,IF(D$5>='Second Schedule'!$B$2:$B$100,IF(D$5<='Second Schedule'!$C$2:$C$1000,'Second Schedule'!$A$2:$A$1000,0),""),0)),"","X")

 

[ulak]

I wish people would put cell references in their screenshots, otherwise it makes any formula solution pretty useless.
I'm assuming the following

the top left hand corner of each screenshot is A1 (otherwise adjust the cell references in the formula)

Array formula

=IF(ISNA(MATCH($A6,IF(D$5>='Second Schedule'!$B$2:$B$100,IF(D$5<='Second Schedule'!$C$2:$C$1000,'Second Schedule'!$A$2:$A$1000,0),""),0)),"","X")

True, I'm sorry. See screenshot.

The formula that you shared doesnt gived the result I wished to see.

 

[ulak]

I wish people would put cell references in their screenshots, otherwise it makes any formula solution pretty useless.
I'm assuming the following

the top left hand corner of each screenshot is A1 (otherwise adjust the cell references in the formula)

Array formula

=IF(ISNA(MATCH($A6,IF(D$5>='Second Schedule'!$B$2:$B$100,IF(D$5<='Second Schedule'!$C$2:$C$1000,'Second Schedule'!$A$2:$A$1000,0),""),0)),"","X")

And I wish to see the date under columns start and eind and not a X under the right date. I hope that this is clear.

 

[Special-K99]

For the Start and End date just do a VLOOKUP or a INDEX(MATCH()) based on the name
So nothing at all under the dates from E5 then?

 

[ulak]

For the Start and End date just do a VLOOKUP or a INDEX(MATCH()) based on the name
So nothing at all under the dates from E5 then?

No, I don't want anything below E5 and beyond. I want to retrieve the start and end dates from the second sheet, but the names appear more than once in the same column and Vlookup shows me the top value. I want the formula to look at today's date and use the correct date after the name based on that. So in this example, when its 30-01-2024 then I will that the formula shows the dates start: 26-02-2024 en eind: 04-03-2024 behind Thaddeus.