I have a excel sheet like this, is there a way to get value in C8 using C6 in VBA?
A non VBA method:
Name the ranges by the their particulars
So, C2 would be
x, C3 would be
y and ...
To do this quickly:
Create from Selection
Leftthen hit OK
This will name the highlighted cells in Column C; x,y,z respectively.
Then your formula in C6 would be:
Then in C8: