Looking up next travel date for staff travel schedule

[ke6zoy]

Hi all! So I am working on a simplistic travel schedule where I'm tracking when team members are traveling for work (T days) and when they're on a customer site (X days). (I'm tracking more than 50 people for perspective)
Each week I send out an email with Columns A and B so that people can have an idea of when they're next expected to travel out to a customer sight that way it there's a surprise, they can work it with their team lead and deconflict any issues.
Is there a good way to automate column B such that it looks at the next T day listed after today's date and returns the value found in row 6? I was thinking it was kind of like a Index Match, however i think it's operating a little bit reverse.

Any insight would be appreciated.
Thanks!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[ke6zoy]

Thanks Office 365.

 

[Fluff]

Thanks for that.
How about

=TAKE(FILTER($C$6:$Q$6,(C7:Q7="T")*($C$6:$Q$6>TODAY())),,1)

 

[felixstraube]

edited... already answered. sorry