Maximum Value lookup in multiple columns

[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

 

[J.E. McGimpsey]

One way:

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

 

[steve rolsl]

Thanks very much.. I would never have gotten that one on
my own ! Steve