Results 1 to 3 of 3

Thread: Staffing Scheduling HELP Match/Index

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

    Staffing Scheduling HELP Match/Index

    Hi I am trying to create a scheduling spreadsheet to pull information from one tab and cross reference it with another. I have a "Shifts to be Covered" tab which tells me that I need a full or part time employee and I want it to index the employee availability tab and pull the proper full/part time employee based on their availability. And then apply that employee's # to the weekly schedule tab.

    I tried doing a index and nested match function but it keeps returning N/A. Can anyone help! Desperatly need it!
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Not able to make out how the values need to be looked up. Can you post the file with the expected output, and mention the logic?
    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

  3. #3
    Junior Member
    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0
    Thanks for the reply,

    Using the Shifts to be covered tab, I want to assign an employee based on their Emp Availability and Full time/Part time status and put that on the weekly schedule tab.

    Another problem I am having, is that Vlookup only gives me the last result, how do I get multiple results for Full time or part time?

    Hope this clarifies.
    Attached Files Attached Files

Similar Threads

  1. Replies: 6
    Last Post: 06-06-2013, 03:17 AM
  2. Replies: 4
    Last Post: 04-24-2013, 10:04 AM
  3. Replies: 16
    Last Post: 04-19-2013, 08:20 PM
  4. Replies: 3
    Last Post: 03-12-2013, 12:54 PM
  5. Replies: 4
    Last Post: 02-22-2013, 02:24 AM

Tags for this Thread

Posting Permissions

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