Excel Formula Help - In Which Year did X Occur

[Sundance_Kid]

Hi,

See the below image, I want a formula to tell me in which year (most recent) was the last amount of Sales greater than 0. AS you can see for Product A that will have been 2021, but for Product B it will be 2024.

Is there some formula that can return the correct (most recent) year.

Thanks

 

[Fluff]

For the lookup function the data must be sorted ascending, {1,0,0,0,0,0} is not.

 

[Arts]

Ah I see after reading up on various internet searches on lookup I was under the impression that the look up data needed to be in ascending order and was that (not so much the looking at the outcome needing to be)

ie The data was arranged 2019, 2020, etc up to 2024

Thanks though I would never have seen that!