functions searching by date

[AJB]

I have a list of items that I need to disseminate by date. All of the items
are recorded in the form 9/15/2008, and I wish to return results by month.
How can I write my vlookup and sumproduct functions to return results by
month?

 

[Fred Smith]

With Sumproduct, you do something like:

=sumproduct(--(Text(a1:a100,"yy-mmm")="08-Sep"),...)

Vlookup isn't going to be as easy. A typical soluction is to add a helper
column with just the month and year. Now you can Vlookup on that, and it
will return the first record it finds, but if you want a specific record,
you'll need to find a way of identifying it.

Regards,
Fred.