A

B

C

D

E

F

G

H

$1$

J

K

L

M

N

P

R

Directions: Create a formula for Cell C$10$ that finds the ratio in Cell B$10$ for the Industry in Cell C$7$ for the Year in Cell C$9.$ This formula needs to be such that Cell C$10$ can be copy$-$paste to Cells C$10$:L$21$ and always find the correct ratio. The data are in Cells N$1$:Q$961.$

$0$

$1$

$2$

$13$

$14$

$15$

$16$

$17$

$18$

$19$

$20$

$21$

$22$

Year Industry

$2019$ Hotels and Restaurants

$2016$ Electric Utilities

$2016$ Hotels and Restaurants

$2020$ Metal Mining

$2019$ Professional Services

$2020$ Life Sciences

$2012$ Electric Utilities

$2014$ Metal Mining

$2017$ Interactive Media

$2017$ Semiconductors

$2020$ Semiconductors

$2019$ Semiconductors

$2018$ Semiconductors

$2014$ Professional Services

$2019$ Electric Utilities

$2021$ Life Sciences

$2013$ Hotels and Restaurants

$2012$ Semiconductors

$2015$ Life Sciences

$2014$ Food Products

$2021$ Electric Utilities

$\backslash$table$[[$Ratio$,$Value$],[$CapX$/$PPE$,0\mathrm{.}1261],[$CapX$/$PPE$,0\mathrm{.}0992],[$Profit Margin,$0\mathrm{.}1435],[$Cash$/$EV$,0\mathrm{.}0626],[$PPE$/$Fixed$,0\mathrm{.}0900],[$Payout Ratio,$0\mathrm{.}1279],[$Cash$/$EV$,0\mathrm{.}0184],[$Debt$/$Value$,0\mathrm{.}2714],[$Debt$/$Value$,0\mathrm{.}0589],[$OCF$/$EV$,0\mathrm{.}0664],[$Dividend Yield,$0\mathrm{.}0151],[$Current Ratio,$1\mathrm{.}8018],[$Dividend Yield,$0\mathrm{.}0202],[$Payout Ratio,$0\mathrm{.}3647],[$EBIT$/$Sales$,0\mathrm{.}2239],[$Fixed$-$MtB$,6\mathrm{.}8797],[$Dividend Yield,$0\mathrm{.}0144],[$PPE$/$Fixed$,0\mathrm{.}3130],[$EBIT$/$Sales$,0\mathrm{.}1725],[$Current Ratio,$0\mathrm{.}7653],[$OCF$/$Sales$,0\mathrm{.}2020]]$