LOOKUP function help

  • Thread starter Thread starter Michael Runyon
  • Start date Start date
M

Michael Runyon

I have an Excel spreadsheet that contains lotteyr results
by day. Each day has a separate row. I have a separate
section that shows the numbers with the last date drawn.
Can I use the LOOKUP function to automatically update the
last date drawn with the latest date value so I do not
have to do it manually? If so, how?

Thanks.
 
The TODAY() and NOW() worksheet functions return the current date. Either could be used as the
item to search for in a VLOOKUP formula. Is that what you are asking?
 
Dan:
-----Original Message-----
Michael

Setup Like
Date Number
June 15, 2003 Number 1
June 30, 2003 Number 2
July 15, 2003 Number 3
July 30, 2003 Number 4

Latest =VLOOKUP(MAX(A2:A5),A2:B5,2,FALSE)

A2:A5 is the range of dates,
A2:B5 is the range containing dates and numbers
2 is the result column (ie lotto number)
FALSE finds an exact match

Dan E




.
Click to expand...
 
Dan:
Thanks for your reply. The values (lottery numbers)
are spread across six columns, not just one. Any ideas
there?
 
Michael,

Set up same as before but with numbers separated
Under the first #
=VLOOKUP(MAX($A2:$A5),$A2:$G5,2,FALSE)
Under the second #
=VLOOKUP(MAX($A2:$A5),$A2:$G5,3,FALSE)
..
..
..
Under the sixth #
=VLOOKUP(MAX($A2:$A5),$A2:$G5,7,FALSE)

Same formula each time but the col # changes

ie 2,3, . . . ,7

Dan E
 
Back
Top