I need to use a vlookup function (on Excel 2010) to calculate the federal withholding tax, how do i do it with this scenario (below)

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.

Report as