Lookup value furthest to the right + criteria

Thank you so much, I'd never have worked that out alone.

Substituting $C$1 for TODAY directly seems to work just as well as having it as a separate cell reference.