Invoices from a Product Catalog
Tutorial: Quickly Generating Invoices from a Product Catalog The reference, lookup, and information functions really shine when you want to build worksheets that automatically carry out a series of boredom-inducing tasks. And they let you tie your information together in interesting ways. Maybe you want to determine monthly wages based on billing rates, build a parts list for an order, or create an invoice based on items that have been ordered from a product catalog. This last task, which is demonstrated in the next example, is sometimes called a dynamic invoicer . It allows sales representatives to quickly create an invoice by choosing from a catalog of company products. The dynamic invoicer employs the following techniques: Looking up information from a table with VLOOKUP( ). Avoiding calculations when data isn't present with IF( ) and ISBLANK( ). Referencing data from another worksheet. Using absolute references to make it easier to copy formulas. ...