Is it possible to use the content (even the text) of one cell for part of the reference of another?
For example, I have several sheets filled with formulas like =A5*B6. I have lot's of these formulas and I would like to set it up so I could change a variable in all of them by only changing one thing.
So, if I have A5*B6, A5*B7, A5*B8, etc. but want to change it across the whole sheet from Bs to Cs. Would it be possible to say A5*(=A1)6 where A1="B", so it would result in A5*B6, or A1="C" and it would change all the formulas to A5*C6.
So, I'd like to use the text or value from one cell as a part of a reference of another.
Is this possible?
For example, I have several sheets filled with formulas like =A5*B6. I have lot's of these formulas and I would like to set it up so I could change a variable in all of them by only changing one thing.
So, if I have A5*B6, A5*B7, A5*B8, etc. but want to change it across the whole sheet from Bs to Cs. Would it be possible to say A5*(=A1)6 where A1="B", so it would result in A5*B6, or A1="C" and it would change all the formulas to A5*C6.
So, I'd like to use the text or value from one cell as a part of a reference of another.
Is this possible?