Vlookup Macro

[superjesse]

Hello folks, I found a vlookup macro in this community and it is very close to what I need. I attached it to this message.

My challenge is this. I have date end only, and I need the macro to sort that way. 

Example data. The top data is the lookup. If my data has a trans date of 5/1/18 then I want the second row to be chosen. The date is less than 6/1/18, but greater than 3/1/18. The macro does it greater than the date, and I need it to do less than. I also have to group by first column. For each person I need this done (example only shows one example for a Person A)

The bottom data set shows what I want to see. I want to add the correct 'Person A #). I've been wracking my brain for hours trying to figure this out. The end result is I'm just adding a column to my data set with the 'Person A -(1 or 2 or 3..etc.)

Thank you so much in advance.

[superjesse]

This is great!!! Thank you so much.