Assuming your first table is in A1:E2 and your second table is in A5:P6
Then in A6 enter formula:
=IF(--(RIGHT(A5,4)&MID(A5,2,1))>=--(RIGHT($A$2,4)&MID($A$2,2,1)),LOOKUP(--RIGHT(A5,4),$B$1:$E$2)/SUMPRODUCT(--(RIGHT($A$5:$P$5,4)=RIGHT(A5,4)),--(--(RIGHT($A$5:$P$5,4)&MID($A$5:$P$5,2,1))>=--(RIGHT($A$2,4)&MID($A$2,2,1)))),"")
copied right
Bookmarks