# How to match 3 variable cells

#### felepen

##### New Member
[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.

Replies
2
Views
70
Replies
5
Views
127
Replies
3
Views
229
Replies
1
Views
95
Replies
28
Views
670

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.

### Which adblocker are you using?

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

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