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.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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