I need to understand the HLOOKUP, VLOOKUP, MATCH, and INDEX fucntions in
Excel 2007 and while I consider myself a fairly intelligent man I cannot get
the solution I need.

I'm trying to summarize hours worked at my company by day and by department.
To input the data I have the dates across the top and the department numbers
down the left side.

I need to have a summary table where the dates are down the left and the
department numbers are on the top.

I will be online on MSN Messenger at if you don't mind
helping a stranger with a career limiting problem.