I am dealing with a vlookup formula to return "comments" into my table. it looks something like this:

=VLOOKUP(A1,'Table2'!$A:$C,2,FALSE)
However, There are duplicate values for Column A and the value that I want returned from column 2 is the latest (dated) entry from column C. For example, The table would be like this:

Job No. Comment Logged Date
XXX222 start 05/01/2015 12:27:53 PM
XXX222 WIP 05/19/2015 01:28:12 PM
XXX222 Finished 05/19/2015 01:56:19 PM



How can I work around this so it captures the newest comment?