Problem with Product Formula

[gheyman]

Here is my data

Index	EscBaseYear	EscToYear	2017	2018	2019	2020	2021
1	2018	2021	1.0557374	1.0678285	1.00	1.00	1.0361346
2	2019	2021	1.019307	1.0236019	1.03066	1.0168599	1.1077434

This formula keeps returning the value 1.00

=PRODUCT(IF((UD_Overrides[#Headers]>=[EscBaseYear])*(UD_Overrides[#Headers]<=[EscToYear]),INDEX(UD_Overrides[#Data],MATCH([Index],UD_Overrides[#Data],0),),1))

Thanks.

 

[gheyman]

=IF([@EscBaseYear]=[@EscToYear],1,(IFNA((PRODUCT(INDEX(UD_Overrides[#Data],MATCH([@Index],[Index],0),MATCH(IF([@EscBaseYear]<2016,2016,([@EscBaseYear]+1))&"",UD_Overrides[#Headers],0)):INDEX(UD_Overrides[#Data],MATCH([@Index],[Index],0),MATCH([@EscToYear]&"",UD_Overrides[#Headers],0)))),"")))

Solved. Thanks.

 

[shift-del]

Ok...
I was working on a formula. And it seems I get different results than your solution. But if the results are OK for you then I can delete my work.

 

[gheyman]

Ok...
I was working on a formula. And it seems I get different results than your solution. But if the results are OK for you then I can delete my work.

Appreciate your time and effort, my results appear to be working for me. Thank you!