Lookups·Scenario·Lesson 33 of 62Pro
Build an invoice from a price list
A real-world job using what the Lookups section covered.
What you’ll do
On the left is a stationery supplier’s price list. In columns E and F is an order: product codes and quantities. You’ll turn it into an invoice.
The steps
4 steps- 1In G2, look up the item name for the code in E2. Fill it down to G6.
- 2In H2, look up the price for the code in E2, and fill it down to H6.
- 3In I2, work out the line total: quantity times price. Fill it down to I6.
- 4In I8, add up the line totals for the invoice total.
Scenario locked
Unlock the other 44 lessons for $49.99
Pro opens every drill, practice set, scenario, project and section review. One payment, yours to keep.