How to match 3 variable cells

[felepen]

[FONT=arial, sans-serif]HI,

I am trying to find a way for below problem, any help be highly appreciated.

I have 2 cells for example C2 and D2, Which are dependent on A2, for example Changing A2 will change both C2 and D2.

Question: if i want to achieve C2=80 and D2: 30, then A2 should be 5. given this scenario how can fix C2 and D2 to desired result by predicting what should be in A2 (It can be through a table of possible values, which can be looked up)

Thanks for help


[/FONT][FONT=arial, sans-serif]
[/FONT]

 

[yesterdays]

Please post some sample of your data and what is your goal in that table