If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Drew949" wrote in message
...
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!