davidrendle999
New Member
- Joined
- Sep 7, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- MacOS
Hi All,
I haven't been able to find a similar query to this that has been answered, apologies if that's the case. I am looking for a way to display a difference between two cells based on a drop down data validation selection. I hope I can explain this properly.
Essentially I have two tables of information. Like this:
Table 1
Table 2
What I would like to achieve is a cell that will display the answer of the 'Table 2's A score e.g 200 minus 'Table 1's A Score e.g 12 based on a cell next to it with a drop down list of A,B,C,D,E,F. So if I selected F I would get '300-23' or E '300-43' etc.
I hope I have explained adequately what I mean here, thank you so much in advance for any support.
I haven't been able to find a similar query to this that has been answered, apologies if that's the case. I am looking for a way to display a difference between two cells based on a drop down data validation selection. I hope I can explain this properly.
Essentially I have two tables of information. Like this:
Table 1
A | 12 |
B | 34 |
C | 52 |
D | 11 |
E | 43 |
F | 23 |
Table 2
A | 200 |
B | 200 |
C | 300 |
D | 200 |
E | 300 |
F | 300 |
What I would like to achieve is a cell that will display the answer of the 'Table 2's A score e.g 200 minus 'Table 1's A Score e.g 12 based on a cell next to it with a drop down list of A,B,C,D,E,F. So if I selected F I would get '300-23' or E '300-43' etc.
I hope I have explained adequately what I mean here, thank you so much in advance for any support.