+ Reply to Thread
Results 1 to 3 of 3

How can I call up a cell from another's relative position?

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    1

    How can I call up a cell from another's relative position?

    Hi All,

    I have 2 sheets in a spreadsheet. 1 has raw data, the other will be the organized version of the first sheet.

    In cell B2 of my second sheet, I want to call a cell from the other sheet. Lets say cell B1 (=Sheet1!B1)
    In cell B3 of my second sheet, I want to call the cell that is 2 columns over & 12 rows down from the cell I called in cell B2 of sheet 2 (=Sheet1!D13). But I want the formula for cell B3 to be based on which cell is referenced in cell B2. I want to do this because I have a repeating dataset that will always have the info I want 2 cells over and 12 cells down from some cell in the dataset.

    I hope this makes sense. Basically, how do I call a cell 2 over & 12 down from a cell I reference?

    Thanks All,

    Jake

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: How can I call up a cell from another's relative position?

    Try:

    =OFFSET('Sheet1'!B1,12,2,,) in Sheet2!B2
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  3. #3
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: How can I call up a cell from another's relative position?

    I think you want the cell referenced (let's call that A) by another cell (let's call that cell B) to be the basis of an offset. So, another cell (C) uses B as its input, but then somehow derives that B is referencing A. Then add the desired offset? If that is correct, then there is no Excel function for that. This code may meet your purposes.
    Please Login or Register  to view this content.
    With my assumptions above, you would type in cell C "=Handle(B,1,1)" where B is "=Sheetx!A". To get the value one row down and one column right of cell A.

    Pauley
    Last edited by Pauleyb; 04-04-2012 at 03:58 PM. Reason: Shortened code

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1