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)