Change The ROW / COLUMN from a formula

[JhonsonTan]

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

 

[Andrew Poulsom]

What doesn't work? What I suggested in Post #34 doesn't use FORMULATEXT.