Answered You can hire a professional tutor to get the answer.

QUESTION

Need help 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

Need help 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!)  

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question