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

 

[Jacob Skaria]

Try the below in M2

="J"&F8

If this post helps click Yes

 

[Gord Dibben]

Check your other post for replies.

No need to multi-post in these news groups.


Gord Dibben MS Excel MVP

 

[Jacob Skaria]

Oops ..

=INDIRECT("J" & F8)

If this post helps click Yes