Simple reference

hsandeep

Well-known Member
Joined
Dec 6, 2008
Messages
1,213
Office Version
  1. 2010
Platform
  1. Windows
  2. Mobile
In Sheet2, A2=Sheet1!D4

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

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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:
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,122
Members
448,550
Latest member
CAT RG

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top