+ Reply to Thread
Results 1 to 3 of 3

INDEX Function on Variable Filename

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2013
    Posts
    22

    INDEX Function on Variable Filename

    I am trying to display the value of cell D2567 from different workbooks, onto a single workbook, using the filename name in the function. For example, I have all of my workbook names in Column C, and in column E, I would like to pull cell D2567 from each workbook.

    In Column E, I have the following formula:

    =INDEX("'D:\Document\["&C2&".xlsx]Sheet1'!D:D,2567)

    I cannot seem to get the variable filename to work, and believe I do not have the quotation marks in the right place. I have tried many different variations but to no avail.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,911

    Re: INDEX Function on Variable Filename

    Perhaps =INDEX("'D:\Document\["&C2&".xlsx]Sheet1'!D:D",2567)

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    Anchorage, AK
    MS-Off Ver
    Excel 2013
    Posts
    22
    Quote Originally Posted by Pepe Le Mokko View Post
    Perhaps =INDEX("'D:\Document\["&C2&".xlsx]Sheet1'!D:D",2567)
    Pepe, that formula still doesn't work and results in an error.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Variable Row Array in Index Match Function
    By Lacaycer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-19-2013, 11:45 AM
  2. [SOLVED] Find if filename exists and update variable within the filename structure
    By Lungfish in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-18-2013, 02:42 AM
  3. Adding a variable to index & match function using VBA
    By prestopr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-07-2013, 05:48 PM
  4. Macro to copy from xls( variable filename) to static xls filename
    By gsp77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 09:33 AM
  5. Replies: 3
    Last Post: 07-09-2012, 03:09 PM
  6. Excel 2007 : Can I assign a variable to an index function?
    By BrackRotus in forum Excel General
    Replies: 0
    Last Post: 02-23-2011, 12:12 AM
  7. Getting an variable index as a function parameter
    By Bruno Saboia in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-27-2008, 02:47 PM
  8. Converting a Variable Filename to a Constant Filename
    By Magnivy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2006, 01:15 PM

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