Cost of 50 Revenues Revenues Gross Profit 51 2016 100 60 40 52 2017 105 61 44 3 2018 110 62 48 64 2019 116 64 52 55 6 Enter VLOOKUP functions in the green boxes below that pulls in the appropriate values from the table above. 7 68 2016 2017 2018 2019 69 Revenues 100 105 110 116 O 1 Enter INDEX and MATCH functions in the green boxes below that pulls in the appropriate values from the table above. 2 3 2016 2017 2018 2019 -4 Cost of Revenues 60 61 62 64 *5 6 Enter OFFSET and MATCH functions in the green boxes below that pulls in the appropriate values from the table above. 7 8 2016 2017 2018 2019 -9 Gross Profit 50 11 2 Cost of 50 Revenues Revenues Gross Profit 51 2016 100 60 40 52 2017 105 61 44 3 2018 110 62 48 64 2019 116 64 52 55 6 Enter VLOOKUP functions in the green boxes below that pulls in the appropriate values from the table above. 7 68 2016 2017 2018 2019 69 Revenues 100 105 110 116 O 1 Enter INDEX and MATCH functions in the green boxes below that pulls in the appropriate values from the table above. 2 3 2016 2017 2018 2019 -4 Cost of Revenues 60 61 62 64 *5 6 Enter OFFSET and MATCH functions in the green boxes below that pulls in the appropriate values from the table above. 7 8 2016 2017 2018 2019 -9 Gross Profit 50 11 2