what is the formula contained in the orange cell (H178)

excel related

00 8 D G 2011 OK Historical Reas 2012 2013 OK OK 2015 2014 OK 2016 OK Forecast Period 2017 2018 OK OK 2019 OK 2020 OK 1554 Ra ABS 2 FINANCIAL STATEMENTS 3 Balance Sheet Check 4 175 Assumption 5% 177 Revenue Growth 75% 178 COGS -15% 179 Discount Rate 54 180 EWEBITDA 155 181 Output Dilver Pos NE The formula contained in the ORANGE cell (H178) is = (SAS177:$G$180, $F$177:$F$180,0), MATCH($A$177,SA$177: SFS 177,0)) Hint: do not forget the 5 when using absolute references. 00 8 D G 2011 OK Historical Reas 2012 2013 OK OK 2015 2014 OK 2016 OK Forecast Period 2017 2018 OK OK 2019 OK 2020 OK 1554 Ra ABS 2 FINANCIAL STATEMENTS 3 Balance Sheet Check 4 175 Assumption 5% 177 Revenue Growth 75% 178 COGS -15% 179 Discount Rate 54 180 EWEBITDA 155 181 Output Dilver Pos NE The formula contained in the ORANGE cell (H178) is = (SAS177:$G$180, $F$177:$F$180,0), MATCH($A$177,SA$177: SFS 177,0)) Hint: do not forget the 5 when using absolute references