=LOOKUP(2,1/(B1:B20=A1),C1:C20)
--

Best Regards,
FARAZ A. QURESHI


"MSSailor" wrote:

Have to lookup for the last day in a column A, The thing is that if I have
more than one similar date, it takes the first one in the column.

Column A
2009-03-03
2009-03-04
2009-03-05
2009-03-06 Mentioned formula picks this value
2009-03-06 I WANT THIS ONE..........

How to add the formula to look after the last day and pick the last value?
This what I have now!
=VLOOKUP(MAX(A9:A36),A9:L36,COLUMN(A20),FALSE)