gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
Here is my data
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.
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.