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!

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!

Sorry, this is probably a better formatted version. I just need to look up
hours based on Code, Date, Name, and whether or not it is billable

CODE: OGSB36
8/29/2009
Name Billable Non Billable
Dave 18 0
Dan 2 0
Eric 4 0

8/31/2009
Name Billable Non Billable
Dave 18 0
Mike 14 4
Eric 10 3

CODE: OCSB56
8/29/2009
Name Billable Non Billable
Steve 3 2
Jeremy 19 13
Eric 4 0

CODE: OLCE33
8/29/2009
Name Billable Non Billable
Nick 3 2
Jeremy 19 13
Eric 4 0

8/31/2009
Name Billable Non Billable
Dave 18 0
Mike 14 4
Eric 10 3

As you can see, there are numerous dates within codes, and different names
from code to code and date to date. Once again, thanks to everyone for your
help

I repeat my offer but will need to see before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Drew949" wrote in message
...
Sorry, this is probably a better formatted version. I just need to look up
hours based on Code, Date, Name, and whether or not it is billable

CODE: OGSB36
8/29/2009
Name Billable Non Billable
Dave 18 0
Dan 2 0
Eric 4 0

8/31/2009
Name Billable Non Billable
Dave 18 0
Mike 14 4
Eric 10 3

CODE: OCSB56
8/29/2009
Name Billable Non Billable
Steve 3 2
Jeremy 19 13
Eric 4 0

CODE: OLCE33
8/29/2009
Name Billable Non Billable
Nick 3 2
Jeremy 19 13
Eric 4 0

8/31/2009
Name Billable Non Billable
Dave 18 0
Mike 14 4
Eric 10 3

As you can see, there are numerous dates within codes, and different names
from code to code and date to date. Once again, thanks to everyone for
your
help