simple question
 

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?

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?

simple question
 

use INDIRECT()

=INDIRECT("J" & F8)
--
Gary''s Student - gsnu200848


"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?

simple question
 

Hi,

In cell M2 enter

=INDIRECT("L"&F8)

If this helped click yes thanks

"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?

simple question
 

Opps
enter J instead of L

"Eduardo" wrote:

Hi,

In cell M2 enter

=INDIRECT("L"&F8)

If this helped click yes thanks

"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?