fill in the yellow, i need to know in excel formula the answer
i need to know the formula on each yellow column.
for example =vlookup(B21,B25-B28) etc
G's Kitchen, Incorporated ("GK, Incorporated") has been crafting fine chocolates for over sixty years, GK, Incorporated is a well-established local brand, but business really took off when GK, Incorporated hired a social media firm to develop a greater online presence. Sales have expanded from a retail storefront in a small Michigan resort town to being sold online and shipped throughout the contiguous United States. Recently, GK, Incorporated signed a retail agreement with a prominent national retail chain. In order to meet the demands of the national retail chain while maintaining a high quality product, GK, Incorporated began leasing refrigerated warehouse space from Penguin Network Storage, LLC to store Just-In-Time inventory of its top products. GK, incorporated has hired you to determine the income tax apportionment percentage in states where it has a physical presence using the data provided in Column G through Column L. The apportionment weightings have been provided below. Required: 1. Complete the client-provided data with SUM formulas for the Everywhere amounts. 2. Complete the apportionment calculations using VLOOKUP formulas to the client provided data in G1:L51 (HINT: Use the FALSE logical value for exact match VLOOKUP formulas. Use absolute referencing for the table array.) California - 100\% Sales California Everywhere Payroll BOY Property EOY Property Average Property Rent Expense-Annualized Total Property Sales rs Apportionment Factor: G's Kitchen, Incorporated ("GK, Incorporated") has been crafting fine chocolates for over sixty years, GK, Incorporated is a well-established local brand, but business really took off when GK, Incorporated hired a social media firm to develop a greater online presence. Sales have expanded from a retail storefront in a small Michigan resort town to being sold online and shipped throughout the contiguous United States. Recently, GK, Incorporated signed a retail agreement with a prominent national retail chain. In order to meet the demands of the national retail chain while maintaining a high quality product, GK, Incorporated began leasing refrigerated warehouse space from Penguin Network Storage, LLC to store Just-In-Time inventory of its top products. GK, incorporated has hired you to determine the income tax apportionment percentage in states where it has a physical presence using the data provided in Column G through Column L. The apportionment weightings have been provided below. Required: 1. Complete the client-provided data with SUM formulas for the Everywhere amounts. 2. Complete the apportionment calculations using VLOOKUP formulas to the client provided data in G1:L51 (HINT: Use the FALSE logical value for exact match VLOOKUP formulas. Use absolute referencing for the table array.) California - 100\% Sales California Everywhere Payroll BOY Property EOY Property Average Property Rent Expense-Annualized Total Property Sales rs Apportionment Factor