Nick needs to create a chart that will always chart today's data. In this quick episode, how to use =TODAY() and VLOOKUP to return today's data.
Transcript of the video:
Learn Excel from MrExcel podcast episode 2339.
How to chart today? Our question from Nick: he has a data set with 3 columns.
He needs to pull a chart of today's data.
Is there some way to have a formula go and grab today's data? Yes there is.
Here is what we're going to do. We are going to put a little formula in here =TODAY().
That formula will always return today Today is July 21st.
Then to get the data from today, Iwill put the headings up there.
Nick has different headings, I am sure. I am using A, B, C.
I don't know if Nick has access to XLOOKUP, so i am going to use =VLOOKUP(.
I want to look up 7/21/2020. I am going to press F4 here: one, two, three one two three times.
That single dollar sign before the A will lock down the formula always look in column A.
So we're always looking for the date from Column a. Comma.
Then down here, from the first date Ctrl+Shift+DownArrow. Ctrl+Shift+RightArrow.
Again, I am going to press f4 to lock that reference. Then I want column 2.
Then type Comma False. In this formula, False means an exact match.
That's going to return the answer from today for column B.
The hassle with this formula: when you copy it over to C and D, it's going to keep giving you Column B.
So you have to come in here and edit the two to be a three. Here: Edit the three to be a four.
All right. Let's check it 7/21/2020.
It is 262 689 886. That is working.
Tomorrow, when we open this workbook, the TODAY() will change to 7/22. It will grab the next day.
For your chart, it is going to be based on those helper cells at the top right.
Nick didn't say he needed help with the chart. You can do whatever you need to do.
There. Add data labels.
Then tomorrow when we open this on 7/22 it's going to grab the next day. There you go Nick. Thanks for sending that question in.
Hey, please Subscribe and ring that bell.
Feel free to post any questions or comments down in the comments below. My new book MrExcel 2020.
Click that "I" in the top right hand corner for more information about the book.
i want to thank Nick for sending that question in.
I want to thank you for stopping by.
I will see you next time for another netcast from MrExcel.
How to chart today? Our question from Nick: he has a data set with 3 columns.
He needs to pull a chart of today's data.
Is there some way to have a formula go and grab today's data? Yes there is.
Here is what we're going to do. We are going to put a little formula in here =TODAY().
That formula will always return today Today is July 21st.
Then to get the data from today, Iwill put the headings up there.
Nick has different headings, I am sure. I am using A, B, C.
I don't know if Nick has access to XLOOKUP, so i am going to use =VLOOKUP(.
I want to look up 7/21/2020. I am going to press F4 here: one, two, three one two three times.
That single dollar sign before the A will lock down the formula always look in column A.
So we're always looking for the date from Column a. Comma.
Then down here, from the first date Ctrl+Shift+DownArrow. Ctrl+Shift+RightArrow.
Again, I am going to press f4 to lock that reference. Then I want column 2.
Then type Comma False. In this formula, False means an exact match.
That's going to return the answer from today for column B.
The hassle with this formula: when you copy it over to C and D, it's going to keep giving you Column B.
So you have to come in here and edit the two to be a three. Here: Edit the three to be a four.
All right. Let's check it 7/21/2020.
It is 262 689 886. That is working.
Tomorrow, when we open this workbook, the TODAY() will change to 7/22. It will grab the next day.
For your chart, it is going to be based on those helper cells at the top right.
Nick didn't say he needed help with the chart. You can do whatever you need to do.
There. Add data labels.
Then tomorrow when we open this on 7/22 it's going to grab the next day. There you go Nick. Thanks for sending that question in.
Hey, please Subscribe and ring that bell.
Feel free to post any questions or comments down in the comments below. My new book MrExcel 2020.
Click that "I" in the top right hand corner for more information about the book.
i want to thank Nick for sending that question in.
I want to thank you for stopping by.
I will see you next time for another netcast from MrExcel.
