Consolidating and calculating data.

[imerial]

Hi guys,

I'm trying to write a formula to help me track how many hours people worked in a week compared to how many hours they were expected to work.

The way I've got it set up is there's two tabs, one with the hours I forecasted them to work (Sheet1) and one with the actual hours they worked (Sheet2). Sheet 3 is the comparison. I need to pull in all the names from sheets one and two, then calculate their actual hours minus their forecasted hours. I know there's a consolidate button on the Data ribbon, but I'm trying to do this with a formula so I don't have to repeat the steps every time.

I understand how to pull in all the names from sheet one, but I don't know how to make excel pull in names from sheet two if they're not on sheet one. I've attached a sample book. Any advice?

Thanks