Modify this Match formula so that it no longer is searching down the column for a match.

[gheyman]

This formula is calculating a compounded escalation factor.

EscalationID	EscalationBaseDate	EscalationEndDate	2023	2024	2025	2026	2027	2028	2029
PPI334418	2023	2026	100.00000%​	105.36688%​	102.06721%​	100.86174%​	100.39575%​	100.21249%​	100.26121%​
PPI25987	2024	2027	100.00000%​	105.36688%​	101.02425%​	100.86174%​	100.39575%​	100.21249%​	100.26121%​
PPI53477	2023	2025	100.00000%​	105.36688%​	102.06721%​	100.86174%​	100.39575%​	100.21249%​	100.26121%​
PPI334418	2023	2025	100.00000%​	108.23754%​	102.06721%​	100.86174%​	100.39575%​	100.26121%​	100.26121%​

=IF([@EscalationBaseDate]=[@EscalationEndDate],1,(IFNA((PRODUCT(INDEX(Create_Esc_Mod_Table[#Data],MATCH([@EscalationID],[EscalationID],0),MATCH(IF([@EscalationBaseDate]<2016,2016,([@EscalationBaseDate]+1))&"",Create_Esc_Mod_Table[#Headers],0)):INDEX(Create_Esc_Mod_Table[#Data],MATCH([@EscalationID],[EscalationID],0),MATCH([@EscalationEndDate]&"",Create_Esc_Mod_Table[#Headers],0)))),"")))

I dont want it to look for a match down the [EscalationID] column because in this new table, that I am trying to adopt this formula for, the [EscalationID] may have different yearly rates.

Is there a way to change this so that its just calculating based on the dates and the matching header data?

Thanks for the help!