Please help with these questions. My formula isnt working in I$5$ or K$5.$ Insert a VLOOKUP function in cell I$5$ to identify and calculate the federal withholding tax. With a taxable pay of $$422\mathrm{.}50,$ Spencer$$s tax rate is $25\%$ and the withholding tax is $$105\mathrm{.}63.$ The VLOOKUP function returns the applicable tax rate, which you must then multiply by the taxable pay.

Calculate FICA in cell J$5$ based on gross pay and the FICA rate, and calculate the net pay in cell K$5.$ Copy all formulas down their respective columns. Be sure to preserve the existing formatting in the document. Based on the hours Spencer worked he paid $$39\mathrm{.}97$ to FICA and had a weekly net pay of $$376\mathrm{.}90$ Use Quick Analysis tools to calculate the total regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and net pay on row $17.($On a Mac, this step must be completed using the AutoSum feature on the ribbon.$)$