From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Join today to access over 25,200 courses taught by industry experts.
Solution: Master the GETPIVOTDATA function - Microsoft Excel Tutorial
From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Solution: Master the GETPIVOTDATA function
(upbeat music) - [Narrator] How did you do? For this one, we can get a head start by hitting Equals and pointing to one of our cells, as such. As you can see, Excel has populated our formula dynamically. Now all we need to do is simply change the reference for product name to be this cell over here. I'll fix the column so that I could drag this to the right for future years. Then for years' order date, I'll point to our year cell and replace it with this value over here. This time, I'll lock the row. I'll hit Enter. Now if this is set up correctly, I should be able to just drag this down and to the right and look at that, the values update. Now I can change any product and the information dynamically updates. Nice work, you're now a GETPIVOTDATA Pro.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.