Hello all, I'm hoping someone can help me figure this out. I have
tried vlookup, lookup, if statements and DGet - with no luck. What I
have:

Workbook with 3 spreadsheets.

Sheet 1 contains entries of hours worked with the following relevant
fields:
Member ID, Week Ending, Hours

Sheet 2 - Detailed info on members

Sheet 3 is a monthly report that I need to hand out detailing the
hours entered per month:

A1 - Member ID

B1 - Weekending

B2 - Hours worked

So, I need to search sheet 1 where the Member ID (A1) and Week Ending
(B1) match and then return into sheet 3, the hours worked (B2)

Sheet one will eventually contain 52 weeks for each of our 30 members.
But there will only be one weekending for each member, ie - Member one
will have only one entry for weekending 10/7/2007, etc... so both
criteria must match.

Thank you.

Polly