Using LOOKUP With Multiple Criteria

I'm making a schedule grid has varying start & stop times. I've made a table so the people using it can check that there is overlap when they are scheduling themselves and the members of their shift.

The rows have the employees and the columns has the hours, (one row for each hour in the year 2013)

Each employee has a 1 under each hour where they work and they can easily see where their shift overlaps onto the next persons and by how many hours. I also have a row on the bottom that checks how many people are on at any given time so everyone can check that we have a minimum number of people on and a maximum number as well.

As it is pretty difficult to look at this grid as it is, i made a 2nd table which we could print to see which days we shoud come in and what time. (with each column being the day/ date and the cell having the time frame one comes in.)

The problem i have is that if any adjustments are done to the first table, (with the hourly columns) it isn't reflected in the 2nd table.

I've created a LOOKUP table with each hour/ shift, but i do not know how to have lookup check the starting hour, the ending hour, and what date it is.

I was considering placing a look-up formula in each cel for each employee for each day for the entire year, i just don't know what the formula should look like.