I am trying to create a spreadsheet that will calculate varying sizes. I need it to reference a key where a letter is an established size such as H=1984, S=672, etc. so as that that column can be changed between a series of letters and the formula will automatically convert the equation.
A | B | C | D Type One | H | 94 | (C1/B1) = 0.047 Type Two | S | 115 | (C2/B2) = 0.171
Where as if I switch H to S the formula will automatically change the value and I receive the correct computation.
A | B | C | D Type One | S | 94 | (C1/B1) = 0.14 Type Two | S | 115 | (C2/B2) = 0.171
Do I have to make a key section that the formula will reference from depending on what is in the cells?