LOOKUP function help

[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.

 

[Myrna Larson]

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?

 

[Michael Runyon]

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




.

 

[Michael Runyon]

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

 

[Dan E]

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