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!
Bookmarks