I have the following formula 

{=INDEX('Hole Section Data J-S'!D:D,MATCH(MAX(IF('Hole Section Data J-S'!H:H=D2,'Hole Section Data J-S'!K:K)),'Hole Section Data J-S'!K:K,0))}
my issue is, is that when the date/time is the same as the one above (even though what is in H:H doesn't match what's in D#) it uses what is listed first. idk its weird. has anyone else had this happen to them before?