match / lookup

[cmichalos]

I am trying to pull together different dates of several (three) different
events for each segment, the reported date, completed date, and compliance
date, all dates are presented in the mm/yyyy format. In addition, each event
has 5 sub events that need to be tracked. I would like to create a graph to
track the cumulative progress of each category and sub category together. I
have created three different pivot tables to pull/collect the number of
segments for each of the various events by date.

In order to graph the data I created one table that I hoped to be able to
collect/insert the number of events based upon the date. I was trying to use
the vlookup command to provide the exact number of events by date but when
the date is not provided in the pivot table it will return the valve of a
subsequent date. I want to have the table with the graph data to search
each pivot table and return the number of segments for each event by date and
if the date is not provided in the pivot table to return a "zero" or blank
value. I have prepared various formulas that work in some instances but do
not cover all instances, I usually end up with a #N/A error when it tries to
find a date that does not exist.

I hope this makes sense, any help is much appreciated

Thanks