Index Match Match returning latest value

Hello all,

I am currently using the formula =IFERROR(INDEX('21 TWL'!$B$3:$Z$26,MATCH(K$2,'21 TWL'!$B$3:$B$26,0),MATCH($A7,'21 TWL'!$B$3:$Z$3,0)),) to return a percentage based off a line number and month.

The formula works in returning the first percentage for that month, but I would like it to return the latest one. For example, in my workbook you will see K2 is 90%, but I would like it to return the 100% which is located below it in the 21 TWL tab.

Any assistance would be greatly appreciated.Sample Workbook.xlsx

mcmahobt,

Thank you for the quick response! Your equation works perfectly.

I was wondering what the "1" input in the first match does? I notice it's the only difference.