Index Function within the last 28 days

Hello,

I am currently using this formula tied to an adjacent cell for reference to find the date that the reference cells value occurred.

=INDEX('16'!A:A,MATCH(F5,'16'!B:B,0))

The problem I'm having is there's about 2 years worth a data and every time that the value matches an earlier entry it gives the first dates occurrence rather than the one listed in the reference cell.

Is there anyway I can use the index function but it only find data within the last 28 days?

I have highlighted the cell in question yellow on the attached sheet. Thanks for your help

That is perfect thank you, and a lot simpler than the method I was about to attempt!