Staffing Scheduling HELP Match/Index

[mgelston]

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!

[Excel Fox]

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?

[mgelston]

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.