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!

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?

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.