davecoppins
New Member
- Joined
- Nov 13, 2018
- Messages
- 11
Hope someone can help
I am trying to change the calculation returned in 1 cell depending on the entry of "X" in another
If an "X" is entered in I2 run the calculation in Worksheet1 - =IF(I$2="x",LOOKUP(AY5,'1'!A$3:B$65)+1)*AY5
If an "X" is entered in J2 run the calculation in Worksheet2 - =IF(J$2="x",LOOKUP(AY5,'2'!A$3:B$65)+1)*AY5
If an "X" is entered in K2 run the calculation in Worksheet3 - =IF(K$2="x",LOOKUP(AY5,'3'!A$3:B$65)+1)*AY5
The formula I am trying to use is =IF(I$2="x",LOOKUP(AY5,'1'!A$3:B$65)+1)*AY5 which works ok as it is but I can't figure out how to get the change to happen when putting "X" in J2/J3
<tbody>
</tbody>
Thanks in advance
David
I am trying to change the calculation returned in 1 cell depending on the entry of "X" in another
If an "X" is entered in I2 run the calculation in Worksheet1 - =IF(I$2="x",LOOKUP(AY5,'1'!A$3:B$65)+1)*AY5
If an "X" is entered in J2 run the calculation in Worksheet2 - =IF(J$2="x",LOOKUP(AY5,'2'!A$3:B$65)+1)*AY5
If an "X" is entered in K2 run the calculation in Worksheet3 - =IF(K$2="x",LOOKUP(AY5,'3'!A$3:B$65)+1)*AY5
The formula I am trying to use is =IF(I$2="x",LOOKUP(AY5,'1'!A$3:B$65)+1)*AY5 which works ok as it is but I can't figure out how to get the change to happen when putting "X" in J2/J3
1 | 2 | 3 |
X | "X" | "X" |
RRP | GP £ | GP % |
=IF(I$2="x",LOOKUP(AY5,'1'!A$3:B$65)+1)*AY5 |
<tbody>
</tbody>
Thanks in advance
David