Create a formula for cell C$8$ that finds the ratio in Cell C$5$ for the industry in cell c$7$ for the year in cell b$8.$ this formula needs to be such that cell C$8$ can be posy and pasted to cells C$8$:J$17$ and always find the correct ratio. Data are in cells L$1$:$0961$

Electric Utilities

$2012$

$2013$

$2014$

$2015$

$\frac{4}{5}2016$

$>2017$

$2018$

$2019$

$2020$

$2021$

$\backslash$table$[[$Industries$],[$Hotels and Restaurants,Interactive Media,Life Sciences,Metal Mining,Professional Services,Semiconductors$]]$