A$1$

Directions: Create a formula for Cell C$8$ that finds the ratio in Cell C$7$ for the lndustyy in Cell B$8$ for the Year in Cell C$5.$ This formula needs to be such that Cell C$8$ can be copy and pasted to cells C$8$:N$15$ and always find the correct ratio.

The data are in Cells P$1$:S$961.$

Year: $2014$

$\backslash$table$[[,$Ratios$],[,$CapX$/$PPE$,$Cash$/$EV$,$Current Ratio,Debt$/$Value$,$Dividend Yield,EBIT$/$Sales$,$Fixed$-$MtB$,$OCF$/$EV$,$OCF$/$Sales$,$Payout Ratio,PPE$/$Fixed$,$Profit Margin$],[$Electric Utilities$],[$Food Products$],[$Hotels and Restaurants$],[$Interactive Media$],[$Life Sciences$],[$Metal Mining$],[$Professional Services$],[$Semiconductors

Industry$-$YR

Ratio$-$IY

Year$-$IR

Industry$-$RY

Ratio$-$Yl

Year$-$RI