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

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