Here's another one:

=LOOKUP(1E10,B2:B10,A2:A10)

Format as DATE

--
Biff
Microsoft Excel MVP


"jb" wrote in message
...
Hi, I am trying to use VLookup to find the last date that a value was
entered
in. I then use this date in a different location to calculate MTD Goals.
My
spreadsheet looks like the following:

Date Total
9/1 $5312.44
9/2 $3419.67
9/3 $1619.17
9/4
9/5
9/6
9/7
to 9/30

This a standard format that is submitted to me with the data. So I would
like to be able to return the date of 9/3 since it is the last day with a
value. Any help would be greatly appreciated as I would then be able to
automate my report without have to enter in the last date of data
available.
Thanks for any help.