Hope all is well, I'm having trouble w a pretty complicated lookup. Here is a
sample of my spreadsheet.

OGSB36
Period End Date Billable Non
Billable
8/29/2009 24
0
Resource
Billable Non Billable
Dave 18 0
Dan 2 0
Eric 4 0
8/31/2009 24
0
Resource
Billable Non Billable
Dave 18 0
Dan 2 0
Eric 4 0
TGB45
Period End Date Billable Non
Billable
8/29/2009 40
0
Resource
Billable Non Billable
Eric 1 0
Sam 27 0
Phil 12 0
9/1/2009 24
0
Resource
Billable Non Billable
Dave 18 0
Dan 2 0
Eric 4 0

This continues in a very long list. I need to look up both Billable and non
Billable hours for each person based on the Code (top), then Datec, and Name,
and put them in another spreadsheet with different formatting (but still
containing codes, dates, and names).
My idea was to write a VBA function such as: LookTime(Code, Name, Date,
Bill) that would return either billable or nonbillable hours, but I think
using conventional functions would be easier. Just not sure how.
Any help would be greatly appreciated.
Thanks in advance!