More specifically:

Column A has a list of dates with times
Column B has a list of names
Column C has either a Yes or No

I need it to locate a specific name in Column B, then find the most recent date with most recent time in Column A corresponding to the name in Column B, then I need it to tell me whether it says Yes or No in Column C.

I've been able to get it to find all the info I need separately but I can't seem to figure out how to get them to work all together.

Hope that made sense, thanks!