Change The ROW / COLUMN from a formula

JhonsonTan

New Member
Joined
Dec 4, 2015
Messages
28
C8 = "20" , K8 = "$1000" , K22 = "$2000"
if c3 = "=c8" , THEN c2 = k8 = "$1000"
if c3 = "=c22" , then c2 = k22 = "$2000"
so if i just need to change c3 value , then c2 will follow
is this possible?
i want the formula in C2 cell
thank you
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Does this work for you?

=IF( C3=C8,K8,IF(C3=C22,K22,"None"))
thanks for the reply andrew
but this wont work if i change c3 to another value (formula)
i want c3 to be flexible to any value (formula)
so i just need to change c3 value , then c2 will follow
 
Upvote 0
Sorry, I don't understand. In what way doesn't the result of the formula change if C3 changes?
what if c3 = c99 ? c2 result would be "None" right? and i dont want that.
i want c3 to be flexible, even it's c100 , c958 , c1953, etc.. so whatever c3 value, c2 will follow.
sorry cant explain it very well

maybe i can say that i want to change the column of the formula from c3 but keep the row
 
Upvote 0
Is this what you want?

=INDEX(K4:K1000,MATCH(C3,C4:C1000,FALSE))
Thanks Andrew !! ure the man.
if i have furthur quiestion can i post it here or should i make anothre thread?

is it possible to make a formula by colour of a cell?
if there is yellow cell in c4:c1000 , then c3 = the value off the yellow cell
or is there something i can use to triger value of a specific cell beside colouring it
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,064
Members
448,545
Latest member
kj9

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
Back
Top