Hello, I can't figure out how to use Excel to do this. I don't really even know where to start. I'm super-awesome with SQL, but Excel has me stumped.

here's the situation: I have a Big List of names, with dates associated with them. Many of the names are duplicated, but have different dates. I am comparing to another Small List of names and dates (no dupes). I need to determine if each name on the Small List occurs in the Big List, and if there is a row on the Big List that is dated later.

Big List
peter 5/1/2001
jim 4/3/2004
mary 5/2/2007
john 3/1/1999
john 5/4/2006
nina 7/7/2000

Small List
adam 9/3/2004
john 4/4/2004

I know how to determine if john happens in the Big List, but I don't know how to dynamically select the maximum date associated with John.

Ultimately, since there is a date in the Big List that happens after the date in the Small List for john, I would like to return true. adam, also in the Small List, would return false because he's not in the Big List at all.

Hopefully that all makes sense. Please let me know if any clarification is needed!