Hello everyone,

I have a row (#2) which contains dates, month by month over 5 years, and another row which contains sales forcasts. I would like to know how I can retrieve the month for which the sales forecasts start (i.e. the first month where forecast is not 0).

I have tried doing so with the following formula:

=INDEX("Dates Row",(MATCH(1,"Forecasts Row",-1))). However, I think my problem is that in order to use the -1 indicator, the data needs to be sorted (in ascending or descending order, idk). I obviously can't do that, otherwise it would mess up my table.

Any tips, help, solutions?

Thanks a lot,

Coco