Task 1 of 6
In F2:F9, pull each category's markup from the lookup table K2:L4.
Lesson theory
The final practice: inventory tracking for a corner store. Pull the markup from a lookup table, calculate the selling price, find the items that need reordering, and value the stock.
Tip: build one column at a time and check the first row right away. A mistake in the first formula gets copied when you fill down.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.