Vlookup values that occur only in the most recent date

Hi all,

I have a file that has two tables. I'm renaming the names of my columns and tables for clarity, but not changing any of the rest of my formula. Table 1 has HR related document numbers, and Table 2 has staff onboard by period. I'm attempting to lookup the HR documents in Table 1 by only the most recent date in Table 2 to determine what is vacant as of the most recent pay period. Can you help with where I'm breaking the formula?

=MAX((TABLE_2[DATE COLUMN]),IF(ISNA(VLOOKUP(A3,TABLE_2[#All],57,0)),"VACANT",VLOOKUP(A3,TABLE_2[#All],57,0)))

I would post a workbook, but unfortunately it's mostly confidential information and would take tons of time to scrub.