Excel VBA Lookup Methods

Excel VBA Lookup Methods

I have an issue that I've been scratching my head at; I've looked into the
Index:Match lookup method, and V/HLookup, but I'm not sure these will help
just yet. Here's what's happening:
I have two worksheets in Excel 07. One has a Customer ID column (which
does and will have duplicate ID's in the instance that the customer did "x
activity" more than one time in a month) and then the date that this
happened in another column. The second sheet is for giving an overview of
a specific day, IE what happened on 7-1-13.
The issue is that my raw data sheet is sorted via the first of the month
descending, so 7-1,7-2,etc, and when I run the Vlookup, if a Customer ID
has a record on 7-2 and on 7-15, the VLookup will pull data only from the
7-2 (first) row. Has anyone experienced this and found a workaround?
My current workaround would be to make either a new table for each day's
data, or instead of using my VLookup of =Vlookup(A2, 'Data Sheet' A:D, 4,
0) to give the columns row numbers, like =Vlookup(A2, 'Data Sheet'
A$1:D$30, 4, 0). This is a daily report, and that would be intense. Please
help if you can!