Pivot worksheet |Business & Finance
Need assistance with pivot table assignment. 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 all_Items tab next to each row of data. Please ensure that your sheet is free of errors (N/A or ref!)
