This is an example of a web-enabled invoice spreadsheet that uses Excel's VLOOKUP function to populate form values.

Enter a Customer ID, add line items using the dropdown menus, enter quantities to calculate results.