- Complete the variable cost percentage column by using a VLOOKUP function. (Hint: use State Type as the lookup value and the information in the VariableCostPct tab as the table_array).
please atleast show me how to do the formula because i am stuck on the Vlookup formula . I keep getting an error
DO 5 = SafetyCoverinsurance-Data-SetA Q Search Sheet Page Layout Formulas Data Review View 9+ Share AutoSum , Home Insert X Cut Copy Paste Format Calibri (Body) - 11 A- A- Wrap Text General 49 H H Fill - B I v A + Merge & Center $ % ) 4.0 .00 .00 0 Insert Delete Format Conditional Format Formatting as Table Cell Styles Clear Sort & Filter A1 fx Region A B D E F G H 1 L N 0 Q R S T U V w Variable Cost Contribution Margin Insurance Type Auto Auto Country USA USA Auto Auto USA USA USA State TX TN CT MA GA UT NV WA MO MS MI Auto Auto Auto Auto Auto Auto USA USA USA USA USA USA Auto Auto ME MT Auto Auto Auto DE ME TN KS OH MA NE Auto Auto Auto Auto 1 Region 2 Midwest 3 Southeast 4 New England 5 New England 6 Southeast 7 West 8 West 9 West 10 North Central 11 Southeast 12 North Central 13 New England 14 West 15 Northeast 16 New England 17 Southeast 18 Midwest 19 Northeast 20 New England 21 Midwest 22 Northeast 23 North Central 24 Northeast 25 Southeast 26 Midwest 27 North Central 28 Midwest 29 Northeast 30 North Central 31 New England 32 Southeast 33 Northeast 34 Southeast 35 Northeast 36 Northeast 37 Southeast 38 Northeast 39 West 40 New England 41 Northeast 42 Southeast 43 Midwest Salesperson Tom Jennifer Crissy Crissy John Kellie Kellie Peter Mario Frank Nicole Sara Peter Fred Sara Jennifer Tom Mike Crissy Dave Matt Mario Fred John Tom Nicole Tom Matt Nicole Crissy John Mike Frank Mike Fred John Mike Peter Crissy Matt Frank Dave Auto Auto VA Sales 883.03 532.41 388.97 821.25 470.51 552.27 430.8 943.11 401.6 476.35 468.17 413.5 509.05 520.28 693.63 665.89 519.56 960.22 497.6 1070.19 955.79 553.44 610.22 505.55 553.44 795.76 567.7 790.34 429.63 346.92 1138.63 479.4 624.83 1018.12 598.54 424.96 530.8 329.38 164.92 456.24 238.28 334.05 USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA Variable Cost Date of Sale Invoice No State Type Percentage 1/1/17 A-2017-000010 TX-Auto 1/1/17 A-2017-000012 TN-Auto 1/1/17 A-2017-000016 CT-Auto 1/1/17 A-2017-000017 MA-Auto 1/1/17 A-2017-000028 GA-Auto 1/1/17 A-2017-000029 UT-Auto 1/1/17 A-2017-000033 NV-Auto 1/1/17 A-2017-000036 WA-Auto 1/1/17 A-2017-000037 MO-Auto 1/1/17 A-2017-000041 MS-Auto 1/1/17 A-2017-000046 MI Auto 1/1/17 A-2017-000050 ME Auto 1/1/17 A-2017-000059 MT-Auto 1/1/17 A-2017-000061 DE-Auto 1/1/17 A-2017-000065 ME-Auto 1/1/17 A-2017-000078 TN-Auto 1/1/17 A-2017-000089 KS-Auto 1/1/17 A-2017-000096 OH-Auto 1/1/17 A-2017-000099 MA-Auto 1/1/17 A-2017-000107 NE-Auto 1/1/17 A-2017-000113 VA-Auto 1/1/17 A-2017-000114 KY-Auto 1/1/17 A-2017-000115 MD-Auto 1/1/17 A-2017-000117 FL-Auto 1/1/17 A-2017-000122 OK-Auto 1/1/17 A-2017-000124 IA-Auto 1/1/17 A-2017-000128 TX-Auto 1/1/17 A-2017-000139 DC-Auto 1/1/17 A-2017-000142 MN-Auto 1/1/17 A-2017-000145 MA-Auto 1/1/17 A-2017-000146 GA Auto 1/1/17 A-2017-000153 PA-Auto 1/1/17 A-2017-000154 MS-Auto 1/1/17 A-2017-000166 PA-Auto 1/1/17 A-2017-000168 NJ-Auto - 1/1/17 A-2017-000170 FL-Auto 1/1/17 A-2017-000178 WV-Auto 1/1/17 D-2017-000008 WA-Disability - 1/1/17 D-2017-000009 Ri-Disability 1/1/17 D-2017-000015 DC-Disability 1/1/17 D-2017-000019 MS-Disability 1/1/17 D 2017-000020 NE Disability Auto KY MD Auto Auto FL OK IA TX DC MN MA GA PA MS PA Auto Auto Auto Auto Auto Auto USA USA USA USA USA USA USA USA Auto Auto Auto Auto Auto NJ FL wV WA Auto Auto USA USA USA USA Disability RI DC MS Disability Disability Disability Disability USA USA USA NE USA MainData VariableCostPct + Ready O a + 100% DO 5 = SafetyCoverinsurance-Data-SetA Q Search Sheet Page Layout Formulas Data Review View 2+ Share AutoSum , Home Insert X Cut Copy Paste Format Calibri (Body) - 11 A A- 5 Wrap Text General 49 H H Fill B I U- A EE Merge & Center $ % ) 4.0 .00 .00 0 Insert Delete Conditional Format Formatting as Table Cell Styles Format Clear Sort & Filter B2 fx 0.58 A B D E E F G H 1 K L N O P Q R s T U U V w Y 1 State Type 2 AL-Auto 3 AL-Disability 4 AL-Home 5 AL-Life 6 AL-Professional 7 AR-Auto 8 AR-Disability 9 9 AR-Home 10 AR-Life 11 AR-Professional 12 AZ-Auto 13 AZ-Disability 14 AZ-Home 15 AZ-Life 16 AZ-Professional 17 CA-Auto 18 CA-Disability 19 CA-Home 20 CA-Life 21 CA-Professional 22 CO-Auto 23 CO-Disability 24 CO-Home 25 CO-Life 26 CO-Professional 27 CT-Auto 28 CT-Disability 29 CT-Home 30 CT-Life 31 CT-Professional 32 DC-Auto 33 DC-Disability 34 DC-Home 35 DC-Life 36 DC-Professional 37 DE-Auto 38 DE-Disability 39 DE-Home 40 DE-Life 41 DE-Professional 42 FL-Auto 43 FL-Disability 44 FL-Home Variable Cost Percentage 0.58 0.3 0.22 0.09 0.29 0.54 0.27 0.26 0.11 0.31 0.61 0.29 0.18 0.12 0.31 0.53 0.29 0.19 0.12 0.17 0.58 0.28 0.23 0.12 0.28 0.51 0.3 0.21 0.13 0.27 0.47 0.26 0.25 0.11 0.18 0.38 0.27 0.19 0.1 0.28 0.45 0.32 0.22 MainData VariableCostPct + Ready a + 100%
