document name reference
document name reference
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: document name reference

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I want to create a formula which refers to a cell in a different wroksheet. However, I want to point to any number of different worksheets, depending on the value I store in an adjacent cell. For example, I would like to use a pointer to cell A2 in my formula below and have the formula insert the "sh2" so the formulat would have the correct document name. Any way to do this without creating a bunch of nexted if statements?

    A1 A2 A3
    10 sht2 vlookup(A1, [A2]!a1:c10, 2)

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi, sorry I am in a bit of a rush, but this sounds to me like you need to use the indirect function.

    RET79

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,797
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    On 2002-04-16 11:48, RobTalbert wrote:
    I want to create a formula which refers to a cell in a different wroksheet. However, I want to point to any number of different worksheets, depending on the value I store in an adjacent cell. For example, I would like to use a pointer to cell A2 in my formula below and have the formula insert the "sh2" so the formulat would have the correct document name. Any way to do this without creating a bunch of nexted if statements?

    A1 A2 A3
    10 sht2 vlookup(A1, [A2]!a1:c10, 2)

    =VLOOKUP(A1,INDIRECT("'"&A2&"'!A1:C10"),2)


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com