Solved Need excel to find today's date and display associate data

March 12, 2012 at 14:20:58
Specs: Windows XP
I have listed sequentially a column of dates (3/1, 3/2, 3/3 etc.) Adjacent to this column I have listed specific sales goals associated for each day. I need help in getting excel to find today's specific day and display the associated sale goal for that day in a designated cel on top of the page. Any help would be greatly appeciated!

See More: Need excel to find todays date and display associate data

Report •


#1
March 12, 2012 at 15:38:38
Try using VLOOKUP and set your lookup_value as TODAY().

e.g.

=VLOOKUP(TODAY(),$A$1:$B$20,2,0)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 12, 2012 at 21:13:09
Thank you; but how can I get excel to display the sales goal from the adjacent column once it has found the correct date? Thanks for any additional help!

Report •

#3
March 12, 2012 at 23:15:21
✔ Best Answer
Have you read the Help files on VLOOKUP?

I am assuming that your dates are in Column A and the sales goals are in Column B.

With your dates in Column A, the formula I offered will return the value from Column B associated with the date that matches TODAY().

The 2 used as the col_index_num argument means to return the value from the second column of the lookup_array, which is A1:B20.

If you are using some other columns, change the lookup_array argument to match, as long as the dates are in the left hand column and your sales goals are to the right of that.

If you have something totally different, then you'll need to describe your set up in more detail.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
March 13, 2012 at 03:39:15
Perfect...thank you!

Report •

Ask Question