Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This retailer is also interested in understanding the business potentials of its local markets. He collected the sales volume in the local markets across 11
This retailer is also interested in understanding the business potentials of its local markets. He collected the sales volume in the local markets across 11 different categories from Jan 2012 to Sep 2013, as shown in the worksheet Sales DataLookup". He hopes you to develop a simple tool using Excel which he can use to look up the sales volume given a specific category and a given month. That is, in the worksheet SalesDataLookup" of "Exercise 2" workbook, cell B17 and B18 are the areas he can input any specified category and month. Please develop the lookup tool in cell B19 of the "Sales DataLookup" tab of "Exercise 2" workbook. Do not worry if B19 says #N/A if B17 and B18 are empty, we will only be grading B19. You may want to use the combination of Index and Match functions to form the formula in cell B19. If your formula in cell B19 is correct, given an input of category and month in B17 and B18, the value returned in cell B19 should be exactly the same as the corresponding cell in the sales data area. Paste BI IC EL $ % ) 40 00 00 0 $ % ) 40 00 00 0
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started