# bug in tricky array formula [closed]

Hello all!

So, with the help of this forum a couple of months ago, I got this epic and tricky spreadsheet done with some very complex formulas, which had stumped me forever until someone brilliant used array formulas to solve my problem.

Now, in using the sheet, there is a bug and I am at a complete loss to get it to work right! Please please you formula gurus out there, help me get this bug figured out.

(I am on LibreOffice Calc 4.2.8.2 in English under linux)

The spreadsheet is here attached, and the problem is in the 'current' tab in the F column. The formula pulls data from the 'advocacy log' tab and is supposed to pull the name of the most recent advocate for the person in question (named in the A column of the current sheet on that same line). It works until two entries have the SAME DATE, then as you can see in the example data, it doesn't work (current.F9 should show as Joshua).

I am so lost in this formula, your help is deeply appreciated.

Thanks, Joshua