functions searching by date

A

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?
 
F

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.
 
Top