MATCH is sensitive to the sort order of the lookup array.
The MATCH function I used was set up to look through an ascending (increasing) column of values as you showed in post 5. Your data now shows a descending (decreasing) sort in the columns.
Untested. For the descending order, change the formulas to
D5:E5 –
=INDEX($A$2:$B$7, MATCH($E$1, $A$2:$A$7, -1),)
D6:E6 –
=INDEX($A$2:$B$7, MATCH($E$1, $A$2:$A$7, -1) -1,)
They are still two-cell array formulas and must be entered with Ctrl+Shift+Enter.