Maximum Value lookup in multiple columns

  • Thread starter Thread starter steve rolls
  • Start date Start date
S

steve rolls

I need some help with a formula that will return a value
based on the latest date in 2 columns.

Column A Column B Column C Column D
10/01/00 4 09/11/99 6
09/27/01 5 11/12/02 7
07/23/03 3 09/23/03 8

the single formula would lookup the latest date value (max)
in the two date columns and return the value in the column
to the right of the max date

the formula should return the value 8 in this case because
09/23/03 is the highest date in the two columns containing
the dates

Thanks Steve
 
One way:

=IF(ISNA(MATCH(MAX(A1:A3,C2:C3),A1:A3,0)),VLOOKUP(MAX(C1:C3),C1:D3,2,
0), VLOOKUP(MAX(A1:A3),A1:B3,2,0))
 
Back
Top