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 8 with the Quarter in Row 86 to match with the 'Key' you created above. The formulas shovild also be written using '\$'s in the addressing so that the formula in cell C87 can be copied across and down. We have calculated the percentage that each quarter represents of each years total sales