How to match 3 variable cells

felepen

New Member
Joined
Mar 23, 2013
Messages
2
[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]
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

yesterdays

Active Member
Joined
Oct 8, 2014
Messages
337
Please post some sample of your data and what is your goal in that table
 

Forum statistics

Threads
1,136,968
Messages
5,678,868
Members
419,787
Latest member
juanam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top