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

simlple question
 

Try the below in M2

="J"&F8

If this post helps click Yes
---------------
Jacob Skaria


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

simlple question
 

Check your other post for replies.

No need to multi-post in these news groups.


Gord Dibben MS Excel MVP

On Wed, 22 Apr 2009 10:09:01 -0700, 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?

simlple question
 

Oops ..

=INDIRECT("J" & F8)

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try the below in M2

="J"&F8

If this post helps click Yes
---------------
Jacob Skaria


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