Almost four hours of searching and tweaking and my spreadsheet's still not behaving. (In my defense, I'm in Day Three of a particularly nasty migraine ...)

My Nth Instance formulas no worky -- anyone good with them?

I know this isn't an Excel Help forum, but the information on those forums haven't been exactly useful, so I'm trying a new tack.

The ultimate goal is to show all purchases for Date X (where date is dynamic and refers to the cell with value =Today() on the summary sheet). Data is pulled from multiple worksheets within the workbook where my summary resides.

Tinkering with LOOKUP to get the purchase relative to the date almost made me cry - I don't know if I'm up for this battle. Help?

(Also, I realized this morning that I now have an answer to "Why do we have to learn this?" if "this" is "Algebraic thinking.")

__________________
one CLEP to go. Pursuing BS English Lit, Excelsior College (115/120) + K-8 certification & MAT, University of Alaska Southeast (15/51).

IC works! Credits by exam to date: 51

GRE: Literature in English (60th percentile / 18 cr)
CLEP: A&I Lit (72), Intro Soc (72), Am Gov (69), Intro Psych (77), Intro to Ed Psych (73), US History I (69)
DSST: Environment & Humanity (70), Civil War (63), Foundations of Ed (68), USSR (54)

On Deck: CLEP Biology, Multicultural Education, Technology in Instructional Design