Returning a year when sales become positive

Hi – 

I have a cell where the output should render the year that sales start in a particular geography, ie.

Europe Launch? XXX

This is driven from another sheet, with the following rows and columns:

Year 2019 2020 2021 2022 2023 2024

Europe 0 0 100 200 400 700

US 0 150 200 400 500 600

 

I’ve been trying to construct a formula using If language to check the “Europe” row, and see when sales start, and thus return the value in the corresponding column showing year of launch in this case, 2021 (or for the US, in 2020 for that matter).

Would be grateful for any comments on how to construct such a formula. Thank you in advance!!

By: Joachim Sabbat

Leave a Reply

Your email address will not be published. Required fields are marked *