The formula contained in the ORANGE cell (H178) is = ($A$177:$G$180, ( ,$F$177:$F$180,0),MATCH($A$177,$A$177: $F$177,0))

Hint: do not forget the $ when using absolute references.

FINANCIAL STATEMENTS Balance Sheet Check Historical Results 2012 2013 2014 2015 2016 Forecast Period 2017 2018 2019 2020 +5%A Rank ABS Output Driver 176 Assumption 177 Revenue Growth +/-5% 178 COGS -15% 179 Discount Rate +/-5% 180 EV EBITDA 2.59 The formula contained in the ORANGE cell (H178) is = ($A$177:$G$180, $F$177:$E$180,0).MATCH($A$177,$A$177: $F$177,0)) Hint: do not forget the $ when using absolute references. FINANCIAL STATEMENTS Balance Sheet Check Historical Results 2012 2013 2014 2015 2016 Forecast Period 2017 2018 2019 2020 +5%A Rank ABS Output Driver 176 Assumption 177 Revenue Growth +/-5% 178 COGS -15% 179 Discount Rate +/-5% 180 EV EBITDA 2.59 The formula contained in the ORANGE cell (H178) is = ($A$177:$G$180, $F$177:$E$180,0).MATCH($A$177,$A$177: $F$177,0)) Hint: do not forget the $ when using absolute references