INDEX MATCH with multiple same dates

What you are missing is that your ranges are not locked and move down as you copy the formula down. This gives the false impression that the formula is working for cases when several dates are the same. When you use the whole column instead it doesn't work anymore since the column reference can't move down with the formula.
Using full columns with arrayformulas is generally a bad idea.
A better way to get control of what ranges to use is to convert the data in Pronto Export to an Excel Table (second from left under the Insert banner). The table automatically expand when data is added and the ranges in the formulas are automatically adjusted. This is definitely the way I would do it.

I used a COUNTIF function to solve the problem with retrieving data with the same date. It seems to work but I'm lazy when it comes to testing.
I also used a ROWS function to get the 1, 2, 3, 4 etc that you had typed manually before.
I used an INDIRECT function to make it possible to just copy the formula to the right. However in order to do that the headers has to be exactly the same so I copied the header names from the Pronto Export tab.

Sometimes when copying right with formulas containing Table references the Table references likes to move along to the right and there is no $-sign to lock them with. One solution to that problem is to select the range you want to fill right to (including the column to copy) and then hit Ctrl + R. Another solution is to use the INDIRECT function.

I did the Transfer FROM Canal -table on the Dartmouth -sheet. I assume you can take it from there.

Good to hear it worked. Before I saw your latest post I had already done some improvements on the formulas.

I downloaded the first workbook you posted and the formulas in the installers sheets didn't work there either. Looking at them they don't even make sense, the installers names are not to be found in the Pronto table.

I don't understand the layout of the installers sheets. How can there be a TO and FROM when the installers are not in the Pronto table? And there is no TO and FROM in the Personal Counts sheet.

If you sort this out I'd be happy to help you setup the other Table sheets and the installers formulas.

I suddenly realized that the installers names are in the Pronto sheet as well. Ok, I did the Brian sheet. Just copy this sheet and change the name on the sheet and in cell A1 and you have the rest.

Copy what? The formula? I'm not sure. The way you typed it in your post your missing a ] but that's just a typo I guess.

If you want to copy the Brian sheet you just right click on the tab and select copy. Or you can just grab the tab and drag while holding down Ctrl.

I see your problem. Here is one way of doing it: http://www.mrexcel.com/forum/excel-q...t-links-2.html

Hmm... Makes me think it's the / that's causing it. If you replace the / with a _ does it work then? Of course you have to change it in the Tables as well as in the formulas.

Another option would be to rewrite the formula to use a cell reference instead of the ProntoTable[Received Date/Time] -string. Something like INDIRECT("ProntoTable["&$A$3&"]") and type Received Date/Time in cell A3.

Why do you need to copy the formulas anyway? I have supplied you with a working Dartmouth sheet which you could just copy to the other places. You also have a working Brian sheet which also could be copied for all the other names. Just copy the whole sheet and you don't have to mess with the formulas.

Totally missed this, sorry! Will look at it now.

He he... I have very little recollection of this workbook. I just solved the little puzzle (implemented the new formula) for Cory. Check that it works as intended (I'm too lazy for that :-) ) I assume you can copy it over to the others or copy the whole sheet and change the name or whatever it was we did.

Hmm... Reading through the whole thread now, it seems you had some copying issues a few posts back. Did you manage to solve that?

I must say I admire your effort and your guts, getting a workbook like this up and running is no trivial task even if you are fluent in Excel. You must be a focused person.
I assume it's a tool for you and you only? My experience is that the more people you involve the more difficult it becomes to keep everyone up to date and prevent everything from crashing.