Article updated on February 09, 2018

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 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.

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