Changes to lookup data to only affect ROWs with todays date or greater instead of all data

[allanio]

Hi all,

I have a previous post that is now solved thanks to Kaper - Many thanks.

But I have run into a new problem with the same spreadsheet:

where any changes I make to the lookup data affects all data when I would like it to only affect ROWS with today's date or greater (future).

This is a problem as I need to refer to dates in the past and be confident in who was working.


Thanks in advance and interested to hear how you would solve this.




Link to related thread: (can't post links, sorry)
Title of related thread: Populate column with names from 2 lists of people with criteria

I will also post the same dummy spreadsheet.