Earliest Date via LookUp?

  • Thread starter Thread starter Bush Kangaroo
  • Start date Start date
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
 
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).
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chinese tombs yield earliest evidence of cannabis use 0
Can Excel return the earliest date from a list? 2
How do I find the earliest date? 1
HELP! Need to have earliest test record data 2
Wishing there was a 'maxif/minif' - your help appreciated! 4
Return earliest date 3
SUMIF Criteria 5
How to find earliest record based on unique identifier from a list ofdata 4

Back
Top