+ Reply to Thread
Results 1 to 7 of 7

indirect reference

  1. #1
    Peo Sjoblom
    Guest

    Re: indirect reference

    =INDIRECT("'["&A1&"]"&B1&"'!B2")

    file name in A1 and sheet name in B1

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "BorisS" <BorisS@discussions.microsoft.com> wrote in message
    news:EC6AF1EB-5123-4A51-A63E-994881902031@microsoft.com...
    >I want to have two cells where one tells me the name of a file, and the
    >other
    > tells me the name of a sheet tab in that file. I would like to be able to
    > use those two values in a cell to complete a reference to a cell (let's
    > say
    > B2 of that file's tab). What is the formatting for this?
    >
    > Thx.
    > --
    > Boris



  2. #2
    Arvi Laanemets
    Guest

    Re: indirect reference

    Hi


    "Peo Sjoblom" <terre08@mvps.org> wrote in message
    news:efDGGpIcFHA.1044@TK2MSFTNGP10.phx.gbl...
    > =INDIRECT("'["&A1&"]"&B1&"'!B2")
    >
    > file name in A1 and sheet name in B1


    But... the file you are referring to must be opened - otherwise the formula
    returns an error!


    Arvi Laanemets


    >
    > --
    > Regards,
    >
    > Peo Sjoblom
    >
    > (No private emails please)
    >
    >
    > "BorisS" <BorisS@discussions.microsoft.com> wrote in message
    > news:EC6AF1EB-5123-4A51-A63E-994881902031@microsoft.com...
    >>I want to have two cells where one tells me the name of a file, and the
    >>other
    >> tells me the name of a sheet tab in that file. I would like to be able
    >> to
    >> use those two values in a cell to complete a reference to a cell (let's
    >> say
    >> B2 of that file's tab). What is the formatting for this?
    >>
    >> Thx.
    >> --
    >> Boris

    >




  3. #3
    BorisS
    Guest

    Re: indirect reference

    is there a way that the error can be avoided? Short of converting to values,
    of course. I'd like these to be similar to other links, where even if I
    don't update them when I open the file (and the source files are closed), the
    previous values still show.

    Thx if you can help out.
    --
    Boris


    "Arvi Laanemets" wrote:

    > Hi
    >
    >
    > "Peo Sjoblom" <terre08@mvps.org> wrote in message
    > news:efDGGpIcFHA.1044@TK2MSFTNGP10.phx.gbl...
    > > =INDIRECT("'["&A1&"]"&B1&"'!B2")
    > >
    > > file name in A1 and sheet name in B1

    >
    > But... the file you are referring to must be opened - otherwise the formula
    > returns an error!
    >
    >
    > Arvi Laanemets
    >
    >
    > >
    > > --
    > > Regards,
    > >
    > > Peo Sjoblom
    > >
    > > (No private emails please)
    > >
    > >
    > > "BorisS" <BorisS@discussions.microsoft.com> wrote in message
    > > news:EC6AF1EB-5123-4A51-A63E-994881902031@microsoft.com...
    > >>I want to have two cells where one tells me the name of a file, and the
    > >>other
    > >> tells me the name of a sheet tab in that file. I would like to be able
    > >> to
    > >> use those two values in a cell to complete a reference to a cell (let's
    > >> say
    > >> B2 of that file's tab). What is the formatting for this?
    > >>
    > >> Thx.
    > >> --
    > >> Boris

    > >

    >
    >
    >


  4. #4
    BorisS
    Guest

    indirect reference

    I want to have two cells where one tells me the name of a file, and the other
    tells me the name of a sheet tab in that file. I would like to be able to
    use those two values in a cell to complete a reference to a cell (let's say
    B2 of that file's tab). What is the formatting for this?

    Thx.
    --
    Boris

  5. #5
    Peo Sjoblom
    Guest

    Re: indirect reference

    =INDIRECT("'["&A1&"]"&B1&"'!B2")

    file name in A1 and sheet name in B1

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "BorisS" <BorisS@discussions.microsoft.com> wrote in message
    news:EC6AF1EB-5123-4A51-A63E-994881902031@microsoft.com...
    >I want to have two cells where one tells me the name of a file, and the
    >other
    > tells me the name of a sheet tab in that file. I would like to be able to
    > use those two values in a cell to complete a reference to a cell (let's
    > say
    > B2 of that file's tab). What is the formatting for this?
    >
    > Thx.
    > --
    > Boris



  6. #6
    Arvi Laanemets
    Guest

    Re: indirect reference

    Hi


    "Peo Sjoblom" <terre08@mvps.org> wrote in message
    news:efDGGpIcFHA.1044@TK2MSFTNGP10.phx.gbl...
    > =INDIRECT("'["&A1&"]"&B1&"'!B2")
    >
    > file name in A1 and sheet name in B1


    But... the file you are referring to must be opened - otherwise the formula
    returns an error!


    Arvi Laanemets


    >
    > --
    > Regards,
    >
    > Peo Sjoblom
    >
    > (No private emails please)
    >
    >
    > "BorisS" <BorisS@discussions.microsoft.com> wrote in message
    > news:EC6AF1EB-5123-4A51-A63E-994881902031@microsoft.com...
    >>I want to have two cells where one tells me the name of a file, and the
    >>other
    >> tells me the name of a sheet tab in that file. I would like to be able
    >> to
    >> use those two values in a cell to complete a reference to a cell (let's
    >> say
    >> B2 of that file's tab). What is the formatting for this?
    >>
    >> Thx.
    >> --
    >> Boris

    >




  7. #7
    BorisS
    Guest

    Re: indirect reference

    is there a way that the error can be avoided? Short of converting to values,
    of course. I'd like these to be similar to other links, where even if I
    don't update them when I open the file (and the source files are closed), the
    previous values still show.

    Thx if you can help out.
    --
    Boris


    "Arvi Laanemets" wrote:

    > Hi
    >
    >
    > "Peo Sjoblom" <terre08@mvps.org> wrote in message
    > news:efDGGpIcFHA.1044@TK2MSFTNGP10.phx.gbl...
    > > =INDIRECT("'["&A1&"]"&B1&"'!B2")
    > >
    > > file name in A1 and sheet name in B1

    >
    > But... the file you are referring to must be opened - otherwise the formula
    > returns an error!
    >
    >
    > Arvi Laanemets
    >
    >
    > >
    > > --
    > > Regards,
    > >
    > > Peo Sjoblom
    > >
    > > (No private emails please)
    > >
    > >
    > > "BorisS" <BorisS@discussions.microsoft.com> wrote in message
    > > news:EC6AF1EB-5123-4A51-A63E-994881902031@microsoft.com...
    > >>I want to have two cells where one tells me the name of a file, and the
    > >>other
    > >> tells me the name of a sheet tab in that file. I would like to be able
    > >> to
    > >> use those two values in a cell to complete a reference to a cell (let's
    > >> say
    > >> B2 of that file's tab). What is the formatting for this?
    > >>
    > >> Thx.
    > >> --
    > >> Boris

    > >

    >
    >
    >


+ 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