Question: How to find the latest date in a list and the adjacent value?

Answer: To find the latest date, type

=MAX(A:A)

in a cell (C1).

To find the adjacent value, type

=VLOOKUP(MAX(A1:A26),A1:B26,2,FALSE)

in a cell (C2).

Download excel sample file for this tutorial.
find-latest-date-in-a-list.xls
(Excel 97-2003 Workbook *.xls)

VLOOKUP(lookup_value; table_array; col_index_num; [range_lookup])
Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in ascending order.

MAX(number1;[number2];)
Returns the largest value in a set of values. Ignores logical values and text.