Problem $1.$ Using vlookups, display the item name, area, and period month on the All Items tab. Hint: You will need to use at least two vlookups to link series$\_$id to area code and then to area.

The end product will display Item$\_$code, Item$\_$Name, Area$\_$Code, Area and Period$\_$Name on the Problem $1($All Items$)$ tab next to each row of data. Please ensure that your sheet is free of errors $($N$/$A or ref!$)$ when it is turned in$.$ VLookups can be a challenge for those who are not accustom to them, please give yourself time to troubleshoot or reach out for help.

Problem $2.$ In this problemyou will take the table you used in the first one and place a pivot table and a pivot graph on it$.$ Pivot tables and graphs are a common tool in Excel and often used when you have thousands, tens of thousands, or hundreds of thousands of lines. If you are wondering, Excel can handle $1,048,576$total rows. Let your curiosity take you on this one.

Create a pivot table of the data you created for Problem $1$ and add a pivot chart of something you find interesting in this data. Filter the data in a way that makes it digestible $($example: one product over $2$ years$).$