Lookup in table

[takisis666]

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.

[takisis666]

Copy of spreadsheet

[wk9128]

worksheet name : Withholding

Cell E6 formula

Please Login or Register  to view this content.

[takisis666]

Thanks for the reply. Got it figured out with the xlookup function.

[wk9128]

@takisis666 XLOOKUP is not very familiar to me, at least the formula is written in the correct direction, why can't the result come out, I am wondering