Extract dates from VLOOKUP

I have a big database which need to extract the three most dates with 6 months into another table when looking up the same ID. I’ve tried a pivot table but can only get “min” “max” results but really need those three dates within the last six months from today and display in another table.

Lookup cell A3 in Sheet 1 from sheet 2 A:A for that ID Number and if more than 3 events and “misuse/other” in cell G:G matches then return the most dates within 6 months back into Sheet 1.

or do I try something completely different?

Samba,
Thanks for your reply and see it returns the Small and Large values, but is there a way to return the next date behind the largest value?

Morning All,
Thanks for the replies already and very sorry on the confusion and some of these do answer my question, but doesnt give me the ability to return all the dates from today and within 6 months having 3 events under the same ID.

Its my fault not giving the right information and having dates older than the six months which hasn't helped you guys so I've uploaded a new spreadsheet showing what it should look like.

Sorry again..
Mike