How to Unlock MS Excel lookup power to the next level? Part 1
When we were asked about our Excel score during the interview for our first job, I believe most of us gave 7–9 points out of 10 normally. This number actually went down in our mind when we start to use Excel in the work especially when we learn what vlookup/ xlooup/ pivot table are.
Knowing these lookup functions are great! But, what’s next?
In this article, we are going to show you how to leverage few more useful functions to bring your vlookup, xlookup skill to the next level.
Raw Data Structure
Tab A: Demand at the product type/ product/ UOM level: Subset of the source data.
Tab B: Demand aggregated into product level
Tab C: Delivery cost per unit at the product level by UOM
