Excel Help - Today's dates based query

[SimonMac]

I have a spreadsheet with a list of dates in ascending order in column A, with various entries in B,C & D.

Is it possible to have a static line, say at the top of the page, that pulls todays dates, looks up column A and pull the subsequent row of data to the top?

I hope this makes sense to someone

 

[MarillionFan]

=VLOOKUP(INT(NOW()),A1:E4,1,FALSE)

Where A1:E4 is your dataset (highlight the area)

The 1 is the column you want to return,

So either 1,2,3,4

 

[SimonMac]

=VLOOKUP(INT(NOW()),A1:E4,1,FALSE)

Where A1:E4 is your dataset (highlight the area)

The 1 is the column you want to return,

So either 1,2,3,4

Cheers fella, if you make it to the Shindig there's a warm shandy with your name on it!

 

[Spacecadet]

Cheers fella, if you make it to the Shindig there's a hand shandy with your name on it!

FTFY

 

[SimonMac]

Whats the difference between NOW and TODAY in excel?

 

[MarillionFan]

Whats the difference between NOW and TODAY in excel?

Now returns a second stamp, which I just happened to truncate using INT

Today returns it without the stamp. So probably better to use that.

I take it you're writing a 'How much I made this month' spreadsheet ;-)

 

[SimonMac]

Now returns a second stamp, which I just happened to truncate using INT

Today returns it without the stamp. So probably better to use that.

I take it you're writing a 'How much I made this month' spreadsheet ;-)

Nah, how much have I got left to spend spreadsheet

 

[MarillionFan]

Nah, how much have I got left to spend spreadsheet

Lots of minuses then.

 

[SimonMac]

Lots of minuses then.

Yeah, day one at new ClientCo I was told the Xmas do is a week away and you'll need a black tie!

 

[MarillionFan]

Yeah, day one at new ClientCo I was told the Xmas do is a week away and you'll need a black tie!

http://27.media.tumblr.com/LfDWf0vGhmn6qlvd5F6omyuHo1_500.jpg

Sorted.