From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Fill in pick list details

Fill in pick list details - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Fill in pick list details

“

- [Instructor] We work in a warehouse and we get these Pick Lists that give us a product I.D., and a quantity. We don't know what these things are. So we've gotta use a Master List on our own to pull the detail over, and the in-stock number, so that we know what we're lookin' for. And, for DC7724, whatever that is, we're supposed to get 14. What if we've only got eight and we've gone all the way to the other side of the warehouse just to find that out? So here is where your help is needed. Take the data in the Pick List. Refer to the Master List and bring over what the detail is and the number in stock. Then, create a summary to let us know if we've got enough of what's needed. Pause the video, fill in this Pick List, come back, and I'll show you a solution. Now there are a lot of ways to solve this, and I'm gonna use Power Query to do this. I'm gonna click inside this data set, go to Data, From Table. Table does…

Contents