Questions 38-39 use the fact pattern on tab Q38-39 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 an HLOOKUP function that will output the correct Net Profit for whichever date 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 row index number.

B) In the last question, you wrote an HLOOKUP function to output net profit. Do you need to include a range lookup to output the correct net profit?

FACT PATTERN Income Statement for Lemonade Co. 12/31/2014 Revenues 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 date: 12/31/2015