Results 1 to 3 of 3

Thread: Lookup Data From Multiple Sheets To Single Sheet Consolidated View Using Formula

  1. #1
    Junior Member
    Join Date
    Mar 2013
    Posts
    1
    Rep Power
    0

    Lookup Data From Multiple Sheets To Single Sheet Consolidated View Using Formula

    Hi all.
    After years i am back on Excel. Just love it.

    I need to lookup data in a sheet. The sheet names are employees names. I have extracted that. But to get the corresponding data to mach is an uphill battle.

    As the months goes on i would like it to look at the next month and bring the data to one sheet. A dropdown i thought.

    If anyone can give me some ideas to get this going, i will be blessed.

    Thanks alot
    Martin
    Attached Files Attached Files

  2. #2
    Junior Member
    Join Date
    Mar 2013
    Posts
    17
    Rep Power
    0
    Hello,

    Can you please reload your workbook but this time include the expected result?
    I will have a crack at it (no promises) but it would help for me to see what result you are trying to achieve.

    Also, on your attachment, Cell A2 has a #NAME? error, which in my understanding comes from the range you have set 'SheetNames' not being defined, by this i mean you have told excel to look in the range 'SheetNames' but you have not actually set that range.

    Regards

  3. #3
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10

    Lightbulb

    So I'm assuming you want to look at all the employees together for any selected month. If that's so, you might find the solution in the attached file useful.
    Attached Files Attached Files
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 4
    Last Post: 06-18-2013, 01:38 PM
  2. Replies: 1
    Last Post: 05-09-2013, 08:56 AM
  3. Combine Columns From Multiple Sheets To One Sheet
    By Portucale in forum Excel Help
    Replies: 6
    Last Post: 04-24-2013, 09:18 PM
  4. Converge Data From Multiple Columns To Single Column
    By ayazgreat in forum Excel Help
    Replies: 3
    Last Post: 12-14-2012, 10:55 PM
  5. Concatenate Multiple Lookup Values in Single Cell
    By Admin in forum Download Center
    Replies: 4
    Last Post: 04-06-2012, 09:07 PM

Posting Permissions

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