# Simple reference

#### hsandeep

##### Well-known Member
In Sheet2, A2=Sheet1!D4

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

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
In the same way?
In cell A3 of Sheet2: =Sheet1!S38

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.

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

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

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.

Offset

=OFFSET(Sheet1!D4,34,15)

Thanks Jommo1.

Replies
7
Views
76
Replies
9
Views
254
Replies
2
Views
97
Replies
4
Views
74
Replies
5
Views
130

1,196,516
Messages
6,015,673
Members
441,915
Latest member
sm Hussaini

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back