Question: need help, keep getting N/A. please provide explanations and formula Year Quarter Q1 Q2 Revenues 10 2018 2018 15 Q3 32 2018 2018 Q4 45

need help, keep getting N/A. please provide explanations and formula Year

need help, keep getting N/A. please provide explanations and formula

Year Quarter Q1 Q2 Revenues 10 2018 2018 15 Q3 32 2018 2018 Q4 45 Q1 10 2018 Q1 2018 Q2 2018 Q3 2018 Q4 2019 Q1 2019 Q2 2019 Q3 2019 Q4 2020 Q1 2020 Q2 2020 Q3 Q2 2019 2019 2019 2019 23 Q3 33 Q4 71 Q1 19 2020 2020 Q2 25 2020 Q3 42 2020 2020 Q4 85 Q4 Q1 2021 20 Q2 30 2021 2021 2021 2021 Q1 2021 Q2 2021 Q3 2021 24 Q3 Q4 65 120 Write formulas in the yellow cells below that rearranges this data in a format that recognizes the seasonality. The formulas should use VLOOKUP functions to pull data from the above chronological presentation. VLOOKUP uses the left-most column of data. The formulas should combine the Year in Column B with the Quarter in Row 86 to match with the 'Key' you created above. The formulas should also be written using '$'s in the addressing so that the formula in cell C87 can be copied across and down. Q2 Q3 Q4 Growth Q1 #N/A Total #N/A Year 2018 2019 2020 2021 Total #N/A #N/A

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Arranging Data Below are sales data for a company that is highly seasonal around the Q4 holidays season. You are going to create a unique "Key" for each year/quarter so that you can use reference...

Hi Vjvgoe, Are you able to help me with this problem please? I would need to see it 7/16/17 since it's due that same week but I will put the deadline on 7/29/17. I have attached all of the...

Summary Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities for charting. The charts will be copied into a Microsoft PowerPoint file and the student...

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Need Help with number 3 DistCo, a large warehouse service company in the San Francisco Bay Area, stores pharmaceutical products for customers while they are in transit to local retailers. DistCo can...

need help in solving financials for Netflix case (Netflix's 2020 Strategy for Battling Rivals in the Global Market for Streamed Video Subscribers), exactly like Lululemon's example below with...

Quigley Inc. is a considering two financial plans for the coming year. Management expects sales to be 300000, operating costs to be 265000 assets to be 200000 and its tax rate is 35%. Under plan A it...

Steam in the condenser of a steam power plant is to be condensed at a temperature of 50°C (hfg = 2383 kJ/kg) with cooling water (cp = 4180 J/kg(°C) from a nearby lake, which enters the tubes...

8. How do you define a segment at an absolute address such as 40h?

Projects A and B are mutually exclusive and both have an initial cost of $88,000. Project A has annual cash flows for three years of $18,300, $34,500, and $52,300, respectively. Project B has annual...

Identify behavior that constitutes sexual harassment, and list things that an organization can do to eliminate or minimize it. page 125

Identify the tasks performed and the skills required in a given job. page 167

Identify the major provisions of the Occupational Safety and Health Act (1970) and the rights of employees that are guaranteed by this act. page 130