Course
Project: order invoice
Turn a product catalog and a customer order into a finished invoice: look up names and prices, catch a code that isn’t in the catalog, find the customer’s discount and add tax.
Exercise 1 of 7
Fill in the product names
Rows 12 to 15 are a customer’s order. In B12:B15, return each product’s name from the catalog in A1:C9 with XLOOKUP. Lock the catalog with $, write the formula once in B12, then copy it down.
| Code | Product | Price ($) | Customer | Discount | |
| A-100 | Copy paper (box) | 34.90 | Brightside Café | 5% | |
| A-120 | Ballpoint pens (50) | 12.50 | Northwind Legal | 10% | |
| B-205 | Stapler | 18.00 | Harbor Dental | 8% | |
| B-210 | Desk organizer | 24.75 | Maple & Co. | 15% | |
| C-310 | Whiteboard markers | 9.90 | |||
| C-330 | Printer toner | 89.00 | |||
| D-400 | Office chair | 249.00 | |||
| D-415 | Desk lamp | 39.50 | |||
| Code | Product | Unit price ($) | Qty | Line total ($) | |
| C-310 | 10 | ||||
| A-100 | 4 | ||||
| D-415 | 2 | ||||
| B-210 | 3 |