+ Reply to Thread
Results 1 to 5 of 5

Index match multiple worksheets

  1. #1
    Registered User
    Join Date
    01-28-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    3

    Index match multiple worksheets

    Hello all,

    Im new to this forum and am currently working on a formula that I'm having alot of trouble with.

    In a nutshell, I am working on an generator that will generate cell item numbers (cell values) based on criteria. Since I have 12 different sheets beginning with week 1 - week 12, I'm basically trying to communicate to excel that if a number is listed on one of the 12 worksheets then tell me the date (another cell value)... then I will deduct todays date from the date it appeared for cycle count reasons. Basically, I already am aware that the countif function does not work with multiple worksheets, but I am looking for index match for different sheets within a workbook.

    I know excel is limited with this, but any suggestions?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Index match multiple worksheets

    Put all data on one sheet.

    Much easier to handle and also much flexiblity.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    01-28-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Index match multiple worksheets

    I could, but the workbook is set up so that another individual just has to print the worksheet after the numbers have been generated. Thats the only issue I have. The sheets are going to be generated by excel and printed. That why I need to keep the data seperate.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Index match multiple worksheets

    It's your choise (of course)

    If it was my workbook, i would put all data on one sheet (in this case).

  5. #5
    Registered User
    Join Date
    01-28-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Index match multiple worksheets

    Thanks for the feedback

+ 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