simple question
try in cell M2
="J" & F8
now it will put the value of F8 in cell M2, with the prefix of "J" in
front of it.
hope that helps!
:)
susan
On Apr 22, 12:57*pm, Darius wrote:
In a cell F8 I have a number as for example: 3115
now in Cell M2 I want to say :
=J3115
Problem is this 3115 number may change, so how M2 value change the J row
number based on the new value?
|