Use vlookup to get the returned values and then combine the results to flag
who, what and when.


--

Regards,
Nigel




wrote in message
oups.com...
I have a employee job scheduling table that I would like to populate
based on criteria from 2 other tables.

The scheduling table has the employee names listed in each row and
across the top is the period of the day broken into 4 time periods.


The critera tables a


1. A training matrix that lists the employee names in each row and
the
jobs listed across the top. If an employee is trained, the
intersecting cell has a "T". If they are not trained, the cell is
blank.


2. An attendance table that lists the employee names in each row and
if they are absent, there is an "A" in the next cell. If they are at
work, the cell is blank.


I'd like to be able to populate the scheduling table based on whether
they are trained and present at work. Basically, each day the
attendance table would be updated and then the scheduling table would
be automatically re-calculated. There would need to be provisions to
prevent the same employee from being scheduled on the same job more
than once a day on a certain job unless no one else was trained.

The format of the tables in am using and the output I would like are
as follows:


Table 1 - Training Matrix (Employees in Col A and Job Names in row 3)
A "Y" means that can work that job.


Job 1 Job 2 Job 3 Job 4 Job 5
Phil Y Y Y Y
Bill Y Y Y Y
Joe Y Y Y Y
Dan Y Y Y Y Y
Tim Y Y Y Y


Table 2 - Attendance - An "A" means they are absent & cannot be
scheduled


Phil
Bill
Joe A
Dan
Tim


Table 3 - Schedule


7am-9am 9am-11am 11am-1pm 1pm-3pm
Phil Job 1 Job 2 Job 4 Job 5
Bill Job 3 Job 4 Job 5 Job 1
Joe
Dan Job 2 Job 3 Job 1 Job 4
Tim Job 5 Job 1 Job 3 Job 2


Any advice on the best way to approach this would be appreciated.

Thanks

Jeff