+ Reply to Thread
Results 1 to 2 of 2

Formula to sheet change

  1. #1
    Sgwapt
    Guest

    Formula to sheet change

    Is there a way To write an Offset formula that changes the sheet name when
    indexed on a cell?

    Ex: =OFFSET(A1!A2,A3,1)

    Where: A1 = sheet name cell value the offset refers to, A2 = start cell, A3
    = row to offset.

    When I use "Sheet1!" in cell A1 it opens the File Not Found dialog.

    --
    George G

  2. #2
    Dave Peterson
    Guest

    Re: Formula to sheet change

    First, drop the ! from A1. You included it in your formula.

    =OFFSET(INDIRECT("'" & A1 & "'!" & A2),A3,1)

    The apostrophes maybe required for some sheet names (with spaces, for instance).



    Sgwapt wrote:
    >
    > Is there a way To write an Offset formula that changes the sheet name when
    > indexed on a cell?
    >
    > Ex: =OFFSET(A1!A2,A3,1)
    >
    > Where: A1 = sheet name cell value the offset refers to, A2 = start cell, A3
    > = row to offset.
    >
    > When I use "Sheet1!" in cell A1 it opens the File Not Found dialog.
    >
    > --
    > George G


    --

    Dave Peterson

+ 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