+ Reply to Thread
Results 1 to 4 of 4

Index with external workbooks

  1. #1
    Forum Contributor
    Join Date
    04-24-2007
    Location
    NYC
    MS-Off Ver
    2k3/2k7/2010
    Posts
    270

    Index with external workbooks

    I'm currently using the index function, indexing workbook A from workbook B, unfortunately the index doesn seem to work unless i have workbook A opened. Is there a way i can still index without having workbook A opened?

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    INDEX should work fine with closed workbooks, although not all functions do, e.g. SUMIF and COUNTIF. What formula(s) are you using, exactly?

  3. #3
    Forum Contributor
    Join Date
    04-24-2007
    Location
    NYC
    MS-Off Ver
    2k3/2k7/2010
    Posts
    270
    =INDEX('\\Computer\Charlie\excel macro\test\test lab.xls'!data, MATCH(C5,'\\\Computer\Charlie\excel macro\test\test lab.xls'!cycle,FALSE),2)


    This is the code data and cycle are name boxes, maybe i should not use those? Thanks.

  4. #4
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Yes, I don't think the defined name in one workbook will be recognised in the other, try using actual cell ranges

+ 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