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