PeterWilson80
New Member
- Joined
- Oct 14, 2019
- Messages
- 2
I am trying to get a formula to build based off a row reference i put into another
I have tried to put a simplified example of what i mean below
E2 is calculated using the formula shown in F2 as an example
So i have 4 columns of data, A - D, and i want to, for the example, minus the fig in D2 from A2, but what i want to do is have the Column Letter pulled from the Cells E1 & F1, so if i changed those entries it changes the formula, so if i wanted to minus the fig in B2 from A2 i would change the D in cell F1 to a B.
Not sure if this is possible or how to do it.
<tbody>
</tbody>
I have tried to put a simplified example of what i mean below
E2 is calculated using the formula shown in F2 as an example
So i have 4 columns of data, A - D, and i want to, for the example, minus the fig in D2 from A2, but what i want to do is have the Column Letter pulled from the Cells E1 & F1, so if i changed those entries it changes the formula, so if i wanted to minus the fig in B2 from A2 i would change the D in cell F1 to a B.
Not sure if this is possible or how to do it.
A | B | C | D | E | F | |
1 | A | D | ||||
2 | 10 | 2 | 4 | 5 | 5 | =A2-D2 |
<tbody>
</tbody>