I am working on a payroll sheet that will extract data from the Federal Tax Chart based on multiple criteria. I have attempted a nested IF, too long, and Match/Index, kept getting a #N/A error.
The idea is to retrieve the tax amount based gross pay, filing status (married, single) and number of exemptions. Sheet one contains status and number of exemptions, sheet one is single, sheet 3 is married, and sheet 4 is payroll info. One of the biggest issues is making it reference the correct row based on the pay range (greater than or equal to column A, but less than column b on sheets 2 and 3. The filing status determines which sheet to pull from, and the number of exemptions determines which column on that page to pull the tax info from.

I know that there are plenty of payroll templates that calculate this, but they all seem to use a percentage rate. My boss is very specific that he wants it pulled from the tax tables.

Any help would be greatly appreciated.

Here are the sheets:
Sheet 1:
Name Pay Rate Married? Exemptions Additional Withholding Garnishments
John Smith 15.00 Y 2 $50 0.00

Sheet 2:
At Least Less Than 0 1 2 3 4 5 6 7 8 9 10
$ - $ 55.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 55.00 $ 60.00 $ 1.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 60.00 $ 65.00 $ 2.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 65.00 $ 70.00 $ 2.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 70.00 $ 75.00 $ 3.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 75.00 $ 80.00 $ 3.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 80.00 $ 85.00 $ 4.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 85.00 $ 90.00 $ 4.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 90.00 $ 95.00 $ 5.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 95.00 $ 100.00 $ 5.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Sheet 3:
At Least Less Than 0 1 2 3 4 5 6 7 8 9 10
$ - $ 170.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 170.00 $ 175.00 $ 1.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 175.00 $ 180.00 $ 1.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 180.00 $ 185.00 $ 2.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 185.00 $ 190.00 $ 2.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 190.00 $ 195.00 $ 3.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 195.00 $ 200.00 $ 3.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 200.00 $ 210.00 $ 4.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ 210.00 $ 220.00 $ 5.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -

Sheet 4:
Period Ending Pay Date Hours Gross Fed Withhold Medicare Social Security Net
1/3/2015 1/9/2015 $ - $ - $ - $ -
1/10/2015 1/16/2015 $ - $ - $ - $ -
1/17/2015 1/23/2015 $ - $ - $ - $ -
1/24/2015 1/30/2015 $ - $ - $ - $ -