B E H K M N N P R Formula Builder Sales Transaction Analysis Show All Functions VLOOKUP Date & Time State Rep Item Brand Units Unit Cost Total Due (With Taxes) Lookup_value = any 1+ Andrews Bindin Andrews Binu aircline Pencil Blaisdell Americar Amelcar 29 76 94 1.99 -VLOCKUP $3.99 #N/A 19.99 #N/A N # Instructions 1. Make the range (13:164 into a tabc Name the table Taxtable 2] Use VLOOKUP lu look up the uupiourale laxrulelu apply lo each larisacioni Inelulle 31 The tomu a that you develop must work n every row for the Total Due With Taxes column. Penalty Points Did not format values correctly Problem with number of decimal places Table_array = number 47 + Col index num - number 46 66 62 2 7 11 2 14 Range_lookup - logical 1/2/09 6:17 MO 1/2/09 4:53 NJ 1/2/09 13.08 L 1/3/09 14:44 TN 1/4/09 12:56 NY 1/4/09 13:19 TX 1/4/09 20:11 NJ 1/2/09 2009 UT 1/4/09 13:17 CA 1/4/09 14:11 TX 1/5/09 2:42 NY 1/5/09 5:39 1. 1/2/09 9.16 CA 1/5/09 10.06 NY 1/2:09 14:18 FL 1/4/09 1.05 NY 1/5/09 11:37 VA 1/6/09 5.02 AZ 1/6/09 7:45 TX 1/2/09 7:35 VI 1/6/09 12:56 VT 1/1/09 11.05 GA 1/5/09 4:10 1 1/6/09 7:16 TX 1/2/09 1:11 FL 1/1/09 2.24 GA 1/7/09 B.CB FL 1/2/09 2:57 NC 1,09 202 NY Sorvino Pen Set Blaisell Andrews Binder Bladell ardina Pon Sci Orar Sorvino Pencil Blaisdell Jardine Desk Blaisell Jardina Pinder Blaisdell Jardine Pindar Orari Andrews Pen Ozark Andrews Pencil Ametcan Thornpson Desk Arneicar Thompson Binder Ozark Smith Binder Ozark GI Pencil Blaisdell Sorvino Pen Set American Pensel Ozark Andrews Pen Set Engle Sorvino Pencil Eaglo Kel Pen Set Eogle Kivel Pen Set Ozark Morgan Pen Set Ozark Morgan Pinrin American ones Pen Set Americar Kiel Desk Ozark Kivel Binder Blaisdell GI Binder Blaisdell Pencil American 57 50 76 8.99 1.99 4.99 1.29 5.99 275 1.29 23.95 19.99 12.49 1.99 1.29 275 4.99 a.99 8,99 23.95 1.29 12.49 4.99 4.99 TE 125 4.99 a.99 # it + # # + # F # + A + + # + it #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A State State Tax Rate AK 4.00 A- 0.03 AR 5.6 AZ 8.57% CA 7.28% CO 2.90% CT 6.355 Result: 0] 7 3 120 40 89 Done Gidire + R22 f VLOOKUP F # it 53 55 96 62 S 50 ao FL GW HI TA ID IL IN KS KY LA 6.00 4.00 4.00 0.004 H.26 7.004 G.ODS 6.50 HOR Looks for a value in the leftmost column of a table. and then returns a value in the same row from a column you specify. By default the table must be sorted in an ascending order. + + # + A # Syntax 6.609 More help on this function B E H K M N N P R Formula Builder Sales Transaction Analysis Show All Functions VLOOKUP Date & Time State Rep Item Brand Units Unit Cost Total Due (With Taxes) Lookup_value = any 1+ Andrews Bindin Andrews Binu aircline Pencil Blaisdell Americar Amelcar 29 76 94 1.99 -VLOCKUP $3.99 #N/A 19.99 #N/A N # Instructions 1. Make the range (13:164 into a tabc Name the table Taxtable 2] Use VLOOKUP lu look up the uupiourale laxrulelu apply lo each larisacioni Inelulle 31 The tomu a that you develop must work n every row for the Total Due With Taxes column. Penalty Points Did not format values correctly Problem with number of decimal places Table_array = number 47 + Col index num - number 46 66 62 2 7 11 2 14 Range_lookup - logical 1/2/09 6:17 MO 1/2/09 4:53 NJ 1/2/09 13.08 L 1/3/09 14:44 TN 1/4/09 12:56 NY 1/4/09 13:19 TX 1/4/09 20:11 NJ 1/2/09 2009 UT 1/4/09 13:17 CA 1/4/09 14:11 TX 1/5/09 2:42 NY 1/5/09 5:39 1. 1/2/09 9.16 CA 1/5/09 10.06 NY 1/2:09 14:18 FL 1/4/09 1.05 NY 1/5/09 11:37 VA 1/6/09 5.02 AZ 1/6/09 7:45 TX 1/2/09 7:35 VI 1/6/09 12:56 VT 1/1/09 11.05 GA 1/5/09 4:10 1 1/6/09 7:16 TX 1/2/09 1:11 FL 1/1/09 2.24 GA 1/7/09 B.CB FL 1/2/09 2:57 NC 1,09 202 NY Sorvino Pen Set Blaisell Andrews Binder Bladell ardina Pon Sci Orar Sorvino Pencil Blaisdell Jardine Desk Blaisell Jardina Pinder Blaisdell Jardine Pindar Orari Andrews Pen Ozark Andrews Pencil Ametcan Thornpson Desk Arneicar Thompson Binder Ozark Smith Binder Ozark GI Pencil Blaisdell Sorvino Pen Set American Pensel Ozark Andrews Pen Set Engle Sorvino Pencil Eaglo Kel Pen Set Eogle Kivel Pen Set Ozark Morgan Pen Set Ozark Morgan Pinrin American ones Pen Set Americar Kiel Desk Ozark Kivel Binder Blaisdell GI Binder Blaisdell Pencil American 57 50 76 8.99 1.99 4.99 1.29 5.99 275 1.29 23.95 19.99 12.49 1.99 1.29 275 4.99 a.99 8,99 23.95 1.29 12.49 4.99 4.99 TE 125 4.99 a.99 # it + # # + # F # + A + + # + it #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A State State Tax Rate AK 4.00 A- 0.03 AR 5.6 AZ 8.57% CA 7.28% CO 2.90% CT 6.355 Result: 0] 7 3 120 40 89 Done Gidire + R22 f VLOOKUP F # it 53 55 96 62 S 50 ao FL GW HI TA ID IL IN KS KY LA 6.00 4.00 4.00 0.004 H.26 7.004 G.ODS 6.50 HOR Looks for a value in the leftmost column of a table. and then returns a value in the same row from a column you specify. By default the table must be sorted in an ascending order. + + # + A # Syntax 6.609 More help on this function