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

Answer: To find the latest date, type


in a cell (C1).

To find the adjacent value, type


in a cell (C2).

Download excel sample file for this tutorial.
(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.

Returns the largest value in a set of values. Ignores logical values and text.