simple question

[Darius]

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?

 

[Susan]

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

 

[Gary''s Student]

use INDIRECT()

=INDIRECT("J" & F8)

 

[Eduardo]

Hi,

In cell M2 enter

=INDIRECT("L"&F8)

If this helped click yes thanks

 

[Eduardo]

Opps
enter J instead of L

Hi,

In cell M2 enter

=INDIRECT("L"&F8)

If this helped click yes thanks