Multiple indexing from cells

Hello all!
I do a lot of excel and am trying to make a new tracker that will be user friendly, I am just having some issues with a code. I attached my sample product. My project is making a vacation matrix. I have one list of people's names with the dates they are taking vacation. Then I have a chart of all those names and a table of dates. If they are taking vacation, I want it to automatically fill in the cell associated with the date. This will make it so I can track how many are on vacation at any given day to make sure we don't have too many people gone.

My issue is that the Indexing will only find the first match (or the 2nd, 3rd, etc.) but not all matches inclusive. When you open my sample you will see that person "1" is taking two different vacation times, but only one is making it up on the chart.

I am currently using code:

Please Login or Register  to view this content.

to draw out the dates. Any assistance will be much appreciated!

AliGW,

Yes a formula, sorry. I am only able to utilize a Microsoft office professional plus 2010 edition, version: 14.0.7232.5000

wow....that works perfectly...I would have never thought of using a sumproduct formula. Thank you very much!

If sumproduct works, then countifs will also work.

Formula:

Please Login or Register  to view this content.

With small data sets there is no real advantage to either, with larger data sets, one could calculate faster than the other.