Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In International Accounting Volume 20

Authors: J. Timothy Sale

1st Edition

0762313994, 9780762313990

More Books

Students also viewed these Accounting questions