Instructions: Questions 40-41 use the fact pattern on tab Q40-41 in the Workbook. You will enter a function for the answer below. Start your formula with the = sign. Do not anchor cell references, i.e. there should be no dollar signs ($) in your answer.

A) Write a VLOOKUP function that will output the correct result for whichever 2018 income statement line item is selected in cell H11. For your answer to be scored correctly, please using C5:H8 as your table array and a hard coded number for the column index number.

B) In the last question, you wrote an VLOOKUP function to show whatever 2018 metric is referenced in cell H11. Do you need to include a range lookup parameter to get the correct answer?

FACT PATTERN Income Statement for Lemonade Co. 12/31/2014 Revenue 1,000.0 Expenses 500.0 Net Profit 500.0 12/31/2015 12/31/2016 12/31/2017 12/31/2018 1,500.0 2,500.0 4,500.0 5,400.0 1,200.0 3,400.0 4,000.0 2,160.0 300.0 (900.0) 500.0 3,240.0 Select the Income Statement Line Item Revenue