-On the Vlookup Table and Validation sheet, create a drop down validation list in cell A4 that only allows the months found in Column A on the Lookup Table sheet. -Turn the data set on the Lookup table sheet into an Excel Table and name it Channel_Sales_Table. -On the Vllookup Table and Validation sheet, use the named table in a Vlookup to return the values for the website sales for the month selected. -Set the Month to Sep so the cell B4 displays $11,764.

A B C D E E 1 Month 2 May 3 Jun 4 Jul 5 Aug 6 Sep 7 8 In Store Sales Mail Order Sales Web Site Sales $6,206 $3,275 $12,016 $17,351 $5,328 $35,371 $11,360 $1,555 $10,822 $28,722 $5,913 $17,243 $7,995 $1,913 $11,764 0 o