Thread: simple question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default 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?