Hey Sccoby,
There's lots of different ways to do what you're asking but here's one
that might work for you.
I have called your weekly data sheet "weekly" and the daily data sheet
"daily" - great naming conventions huh ?
Column A in both has name, Column B Dates (as date numbers !) and
Column C has amounts.
The first row of actual data occurs in row 2.
In worksheet "Weekly" in cell E2 i have the following formula.
=SUMPRODUCT((Daily!$A$2:$A$16=Weekly!A2)*(Daily!$B $2:$B$16<=Weekly!B2)*(Daily!$B$2:$B$16=Weekly!B2-6)*(Daily!$C$2:$C$16))
I have atached a little zip file, at least I hope I have :-)
Mike
+-------------------------------------------------------------------+
|Filename: Nested Vlookup or alternative.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3957 |
+-------------------------------------------------------------------+
--
Grandslam90
------------------------------------------------------------------------
Grandslam90's Profile:
http://www.excelforum.com/member.php...o&userid=17408
View this thread:
http://www.excelforum.com/showthread...hreadid=480077