Earliest Date via LookUp?

B

Bush Kangaroo

is it possible to select the earliest date from a list via
vlookup?What should my formula look like?

Many Thanks for your assistanc
 
T

Tudor

I guess you would have to sort the table with your variable and date ascending first and then use the vlookup function. ie =VLOOKUP("A",A:B,2,0). I would be tempted to automate the sort (possibly everytime you enter the formulae sheet).
 
D

Dave O

In Excel, a date is actually a number: if you have a date cell, try
formatting it as a number to see what it looks like. Excel formats
that number so it is presented on screen in a date format. Since a
date is actually a number, you can use the Min() function to get the
earliest date.
 
Top