Procedure Objective Command Comment 1. Look for duplicates Occurrence Conditional Easy to do with formatting conditional formatting 1 Look for gaps Compute gap field More difficult to do than of difference in duplicates invoice number (should be 1) and filter. 2. Each shipment (BOL) VLOOKUP Add invoice number to associated with shipping file using invoice VLOOKUP on BOL. 3. Invoice within 5 days Timing Compute gap field Easy to compute of shipment and filter Sales are made to VLOOKUP Add customer number authorized customers from customer file to in customer file invoice file using VLOOKUP. 51 3-way match of VLOOKUP Bring Prod. No. and quantities and product Quantity from both sales number between a order and bill of lading sales order, Bol, and files into invoice file. invoice 6. Invoice total is correct Accuracy Computed field Easy to recompute price x quantity and compare to invoice total