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.