H 1 Vlookup assignment 2 We are going to create invoices using the vlookup function for product prices and shipping costs 4 We will group the sheet tabs to minimize the typing required. Sheet tabs will be renamed. 5 When using lookup tables, true yields the closest lowest match, not necessarily the closest match. 6 For example, 197 will match 100 not 200. T K M N 8 Open a new file, and click on sheet tab 1, 2, and 3 (you can use the control key or the shift key as they are adjacent tabs) Sheet tab names can have Right click on the highlighted tabs and chose insert, worksheet, ok (since you had clicked on 3 worksheets first, your action cosulted in 3 new woheetspaces contrary 10 Rename the worksheet tabs: 11 to when we do range names Sheet 1 Product List (right click on the tab, chose rename and type the name) 12 Sheet 2 Shipping Cost 13 Sheet 3 14 Sheet 4 15 Sheet 5 Sales Invoice net 30 (money due 30 days from date of invoice) Sales Invoice 1 15 (remember from accounting the term 1/15 meant if paid within 15 days, you getke a 1% decount) Sales Invoice 2 10 (if pay within 10 days of invoice date, you can take a 2% discount) 16 Sheet 6 17 Reorder sheets so Sales Invoice EOM (money due at the end of the month) that Product list is in 18 Click on the Product List tab the first sheet position, Shipping Cost is in second, etc. through 6th place (Remember this is formerly Sheet 1 which has now been renamed) 19 41 Your name 20 di Tables column b on this worksheet indicates the cell where the information in column c should be entered, when necessary 21 04 Product 22 as cake 23 26 cookies 24 a7 coffee 25 creamer 26 09 cups 27 410 muffins 28 all nuts 29 a12 plates cil to put information in from column C, so for example, you would put your name in a information to be entered in cell indicated in column B, so the word cake would go into a 30 al3 silverware 31 a14 sugar 32 415 tea 13 b4 Price 34 b5 7.99 15 66 5.99 36 67 4.99 37 bs 2.69 38 b9 3.29 39 b10 5.95 40 bil 4.99 41 612 2.99 42 613 1.29 41 614 3.29 44 b15 3.29 45 Autofit column A 46 There can be no duplicates in column A as this is the item being referenced. 47 48 Click on the shipping cost tab (this is formerly sheet 2) column a is the cell location for where the information in column b will be entered, so for example, the phrase sale amount goes into al 49 43 Sale Amount 50 4 0 $15 100 5206 200 53 47 300 54 400 500 56 10 600 57 11 1000 58 12 5000 50 13 10000 Instructions Sheet Sheet