Use a vlookup function to calculate the federal withholding tax. With a taxable pay of $417.40, Abrams tax rate is 25% and the withholding tax is $104.35. The vlookup function returns the applicable tax rate, which I will then multiply by the taxable pay.