Match assessment time with medication administration

Hello all, First time posting after learning quite a bit from the site, for that, thanks a bunch. My current issue is using index and match, while I normally get the result I'm after, all of a sudden I've hit a spot of bother with trying to match two criteria while trying to get a time closest to the administration time. Here is an example of what Ive done so far.

PATIENT NAME      ADMINISTRATION   DRUG GIVEN
JONES, RICHARD    4/1/15 0:01      oxyCODONE
THOMAS, ROBBIE    4/1/15 0:26      HYDROcodone-acetaminophen  5-325 mg
SMITH, PAUL       4/1/15 1:47      morphine inj
ROSS, LYDIA       4/1/15 0:30      HYDROcodone-acetaminophen  5-325 mg
JACKSON, JOSEPH   4/1/15 1:54      HYDROmorphone inj
DUMAS, ALEJANDRO  4/1/15 2:30      HYDROcodone-acetaminophen  5-325 mg

On another sheet I have a similar list, but it contains all the assessment times

JONES, RICHARD      4/1/15 0:01	awake and alert (1)
WAYNE, GARY 	    4/1/15 0:10	slightly drowsy, easily aroused (2)
THOMAS, ROBBIE	    4/1/15 0:20	awake and alert (1)
JOHNSON JR, JACK    4/1/15 0:25	sleep, easy to arouse (S)
RUTH, VICKIE        4/1/15 1:00	sleep, easy to arouse (S)
DEAR, SHARON        4/1/15 1:00	sleep, easy to arouse (S)
JONES, RICHARD      4/1/15 1:01	slightly drowsy, easily aroused (2)
THOMAS, ROBBIE      4/1/15 1:38	sleep, easy to arouse (S)

So on the main sheet of the excel file, I've listed all the medication administrations with the nurses, and I"m trying to match up the closest assesment times to see if the assessments were done in a timely manner if at all. this is what I have so far...

=INDEX(Assessment!$H$2:$H$6951, MATCH(MIN(IF("*"&Dashboard!$D3&"*"=Assessment!$C$2:$C$6951, ABS(Dashboard!E33-Assessment!$H$2:$H$6951))), IF("*"&Dashboard!$D3&"*"=Assessment!$C$2:$C$6951, ABS(Dashboard!$E$3-Assessment!$H$2:$H$6951)), 0), 1)

The dashboard pulls all the administration times, and this is where I'm trying to match all the different assessment times....The wildcards were a last stitch error to try and correct the N/A error I kept getting.

Hope this helps