+ Reply to Thread
Results 1 to 3 of 3

refer to specific worksheet

  1. #1
    Dirk Nachbar
    Guest

    refer to specific worksheet

    Dear all

    I want to refer to a cell in a worksheet by writing down the worksheet
    in A2. I tried =CONCATENATE("=",A2,"!A1") but it will write down the
    formula =sheet2!A1
    as a string and not evaluate it.

    Dirk


  2. #2
    Muhammed Rafeek M
    Guest

    RE: refer to specific worksheet

    hi
    use INDIRECT function

    "Dirk Nachbar" wrote:

    > Dear all
    >
    > I want to refer to a cell in a worksheet by writing down the worksheet
    > in A2. I tried =CONCATENATE("=",A2,"!A1") but it will write down the
    > formula =sheet2!A1
    > as a string and not evaluate it.
    >
    > Dirk
    >
    >


  3. #3
    Joerg
    Guest

    Re: refer to specific worksheet


    "Dirk Nachbar" <dirknbr@googlemail.com> wrote in message
    news:1153470903.807479.127810@i42g2000cwa.googlegroups.com...
    > Dear all
    >
    > I want to refer to a cell in a worksheet by writing down the worksheet
    > in A2. I tried =CONCATENATE("=",A2,"!A1") but it will write down the
    > formula =sheet2!A1
    > as a string and not evaluate it.
    >
    > Dirk
    >


    Try =INDIRECT(A2&"!A1")

    Cheers,

    Joerg



+ 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