I am creating a spreadsheet to figure taxes for payroll. I have the computations for the SS and medicare. I am using the tax table from the irs pub. I need assistance is getting the sheet to lookup the correct value in the table based upon the amount of pay. Here is the table:
Exemptions 0 1 2 3 4 5 6 7 8 9 10
$0 $170 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$170 $180 $1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$180 $190 $2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$190 $200 $3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$200 $210 $4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
I need it to look between the first and second column and the look to the right based upon the number of exemptions. Example: pay is $185 so it has to look at which line that falls between and then move to the right to the column that has the number of exemptions example 1 exemption which would put it into the second.
=XLOOKUP(B10,'Tax Table'!A7:B129,XLOOKUP(E3,'Tax Table'!C5:M5,'Tax Table'!C7:M129)) formula I am using but not working.
Any help is appreciated.
Bookmarks