INDEX MATCH with my input dates vs dates from data logger

[Prevost]

Hi There. This has undoubtedly been asked before but here I go. I import an Excel data sheet from a piece of data logging equipment. In one column there is date & time in the format mm/dd/yyyy hh:mm and the adjacent column contains a temperature. The date & time cells increment in 1 minute intervals. I then create a MASTER sheet and type in the first date of recorded data, then increment the date & time column in 1 minute intervals by using ='Previous Cell' + time(0,1,0).

Then I use INDEX MATCH to find the date & time cell in the other sheet (there are actually multiple data sheets, which I why I created the MASTER sheet to consolidate the data) and the corresponding temperature. Only problem is that the cells returns #N/A and I don't know what's going on...I input an exact match and that should work because the dates are the same but I am missing something...

Thanks!

 

[svendiamond]

Maybe it's not the same date/time format? Maybe your formula is an array formula and requires CTRL+SHIFT+ENTER... post some sample data or the formula you used and maybe it will be easier to help.

 

[Prevost]

Thanks! How do I post my workbook? I know there's not a feature on here last time I checked...

It has happened again in a different instance, the first two INDEX MATCH formulas work, and then it goes to #N/A which leads me to believe there is some underlying issue here...the first two values are correct when they match the exact values...