Simple reference

[hsandeep]

In Sheet2, A2=Sheet1!D4

Now how to get Sheet1!S38 in A3 (of Sheet2).?

 

[Vidar]

In the same way?
In cell A3 of Sheet2: =Sheet1!S38

 

[hsandeep]

Not in that straight manner. But with some 'reference' formula. I hope I had explained. i.e. by referring cell Sheet1!D4. I think there is some formula which will get values of of moving right/left & up/down.

 

[Vidar]

Something like this?
=INDIRECT("Sheet1!S38")

 

[hsandeep]

No. I dont want to use S38. Instead something like 15 rows right of D4 & 35 cells down of D4 or by referring cell cell A2 of Sheet2. I dont know how to build this kind of formula

 

[hsandeep]

I think there is some formula which picks up value n columns right/left & m rows down/up. Using this formula PROBABLY, the answer may come. I want to get In Sheet2!A3, value of Sheet1!S38.
I have Sheet2!A2=Sheet1!D4.

 

[Jonmo1]

Offset

=OFFSET(Sheet1!D4,34,15)

 

[hsandeep]

Thanks Jommo1.