Index match, within a certain date range

[Spreadsheetdaunting]

I am using 2 spreadsheets the first is called "DPR" and has the date in column A with each row representing 1 day. THE second is called "ZPL" and has the date and time in column A with each row representing 1 minute.
the formula below will be contained in column B OF "DPR" and will reference "ZPL".


=INDEX(zplA2:A200000,MATCH(1,C2:C200,0))

How can I modify this formula so that it only applies values in the ZPL array a2:a20000 that have the same date stamp as the corresponding date in the A column of DPR?

I want it to be more like this. INDEX(only the part of zplA2:A200000 that contains the same date as DPR A2,MATCH(1,C2:C200,0))

[Ace_XL]

Try..

=INDEX(zplA2:A200000,MATCH(A2,C2:C200000,0))

[Spreadsheetdaunting]

Ok so that is good, but the match critera also has to find the value 1 in the Row c array....can I combine the 2 requirements some how?