315 B C F D Prob 3 Save your work Use VLOOKUP to find the Industry Name (based on Industry Code) for each company Place Industry Name in column H, for each company. Industry Names and Codes are in columns L through N. The formula output should update appropriately if the input values change Do not change the formatting of COLUMN C. The vlookup should work regardless of whether this formatting is changed or not. Do not insert, delete, move, or "name" any rows, columns, or range. Do not convert any range of cells into a table Do all calculations in the cells designated for the problem (H10 through H44). Do not add any additional items. Price 52. Price 52 Industry Market Cap EPS Trail Industry Ticker Company Week Code Week Sector (Min) Industry Name 12 MO Code Industry Name Low High 10 Gedan Activewear GL 315 4,156 16 32 35.11 0.87 Consumer Goods Apparel 11 Jarden Corp JAH 339 4.104 28 66 55 77 2.73 236 Consumer Goods Homebuilding 12 Perigo Co PRGO 325 9.585 88.65 120.78 4.60 339 Consumer Goods Household Products 13 Roper Inds ROP 334 11 002 78.95 113.17 4.71 721 Entertainment Hotel/Gaming 14 Diamond Foods DMND 311 287 12.85 40.71 1.02 312 Food Stuffs Beverage 15 Mylan Inc MYL 325 10.791 17 22 26.58 1.44 311 Food Stuffs 16 Eaton Corp Food Processing 335 17 142 36 38 53 06 4.21 327 Industrial 17 Watson Pharmac WP 325 10,896 Chemical (Basic) 55.00 90.00 6.19 334 Industrial 18 Wyndham Worldwide WYN T21 6,947 Machinery 3244 55 41 2.95 336 19 Medicis Pharmac MRX 325 Manufacturing 2.441 Auto Parts 43.70 2.29 20 Sanat ADR SNY 329 Medical 325 115,719 31.61 Biotechnology 2.75 21 Dr Pepper Snapple 45.72 DPS 312 325 9,176 Medical 34.68 45.85 285 22 Regal Belot Drug RBC 334 47.34 2.787 517 Service 75.60 2 Jones Group (The) Cable TV 4.74 JNY 315 859 8.13 24 PAREXEL Int 13.98 1 06 PRO 325 1.875 18.24 25 Hospitaine 1 19 32.47 325 HSP 4,830 25 Virgin Media 26 92 38 49 1.96 VMED 517 9.050 20.52 MOS 128 327 34.51 20 Molson Coors Brewing TAP 22.010 44.43 61.98 424 312 29 Spectrum Brands 7.254 37.96 SPE 4.14 46.35 309 30 Questco Pharmac 2.321 OCOR 48 22 329 2.31 1.508 31 Cooper Tire & Rubber CTB 17.25 58.91 262 336 1,512 12.32 336 24.45 2.77 33 Briggs & Stratton 818 16 86 BGG 334 230 34 Liberty Global LBTYA 940 12.96 517 20.10 15 284 Medicines Company MDCO 0.98 325 37.66 62 86 -2.67 LLY 1,128 325 26.95 53,091 RHP 0.92 121 53.99 1,409 3.40 GIS 311 41.75 0.33 WBC 36.75 336 4105 2.57 SNA 334 4.72 COKE 312 4.524 4791 80.45 605 5.04 51.53 Instr 302 prob 1 prob 2 prob prob 4 prob 5 probo prob 7 probe prob 9 prob 10 prob 11 prob 29.76 27 Mesa Company 24 24 29.95 3 Ryman Hospitality 172 35 46 19.08 WABCO Hoge Coca-Cola Baling 26.089 3.778 38 97 70 93 Type here to search IT