Results 1 to 5 of 5

Too many instances of "INDIRECT"?

Threaded View

  1. #1
    Registered User
    Join Date
    04-04-2009
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Too many instances of "INDIRECT"?

    Hi folks!

    Well, I only dabble with Excel occasionally, but whenever I do, boy, do things get ambitious. Now I've run into a bit of a brick wall trying to reference one worksheet from another, with the specific worksheet referenced being variable (it looks for the worksheet name in cell D3).

    I formerly had this, the "hard-coded" version:

    =SUM('2009'!F4:OFFSET('2009'!F4,(MATCH(B3,'2009'!A4:A15,0)-1),0,1,1))

    I want to replace "2009" with the lovely and helpful INDIRECT function, and have managed to get to this point:

    =SUM('2009'!F7:OFFSET(INDIRECT(D3&"!F7"),(MATCH(B3,INDIRECT(D3&"!A7:A18"),0)-1),0,1,1))

    However, I can't for the life of me get rid of that first reference to "2009" by replacing it with a third "INDIRECT" function. I'm sure I'm putting the brackets and quotes in the right place but i always get an error.

    Here's what I'm trying:

    =SUM(INDIRECT(D3&"!F7:OFFSET(INDIRECT(D3&"!F7"),(MATCH(B3,INDIRECT(D3&"!A7:A18"),0)-1),0,1,1)"))

    Am I just missing something incredibly obvious?

    Any help is much appreciated... thanks!

    Adam
    Last edited by cosmocanuck; 04-04-2009 at 02:49 PM.

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