Multiple Arguments: Problem = Vlookup to show last review date

I have a few criteria I want to include in one formula to ease the daily updating process. I believe I need to add an Array into the middle of this somewhere. Any help greatly appreciated.

Criteria
1. Notate if ID is a duplicate.
2. If ID is a duplicate, has it been reviewed in last 30 days from trigger date? (Problem with my formula is that it grabs first review date only)
3. Column to show Yes or No if ID needs to be reviewed.

Thank you!

=IF(E10="Duplicate",IF(D10-(VLOOKUP(A10,A:G,7,0))>30,"Yes","No"),IF(G10="","Yes","No"))

Update!

Ok so I figured out I can use an array to pull the last time any ID has been reviewed. Problem is that I cannot subtract the Array value from Trigger date. It keeps giving me 0 as a result. Anyone have a work around to get the difference between the two dates? Also is there a way to put this array into my original formula to make this all in one cell? Thank you!

=MAX(IF($A$2:$A$5000=A3,$G$2:$G$5000))