Spreadsheet: 39550d1237827655-if-vlookup-payroll
Sheet: Employee Info

 | Employee  ID | Name | Social Security Number | Position | Pay Category | Date Hired | Tax  Status | Federal Allowance  (From W-4) | State Tax  (Percentage) | Federal Income Tax  (Percentage based  on Federal Allowance) | Social Security Tax  (Percentage) | Medicare Tax  (Percentage) | Total Taxes Withheld  (Percentage) | Insurance Deduction (Dollars) | Other Regular Deduction (Dollars) | Total Regular Deductions  (Excluding taxes, in dollars) |  | Position |  | Category
 | 12345 | [NAME] | 999-99-9999 | General | C | 2000-01-01 00:00:00 | 1 | 4 | 0.023 | 0.28 | 0.063 | 0.0145 | 0.3805000000000001 | 10 | 10 | 20 |  | General |  | A
 | 22222 | [NAME] | 888-88-8888 | General | B | 2001-01-01 00:00:00 | 1 | 1 | 0.026 | 0.32 | 0.08 | 0.02 | 0.4460000000000001 | 10 | 10 | 20 |  | Tech |  | B
 | 33333 | [NAME] | 777-77-7777 | General | A | 2002-01-01 00:00:00 | 1 | 2 | 0.029 | 0.36 | 0.097 | 0.0255 | 0.5115 | 15 | 15 | 30 |  | A Manager |  | C
 | 44444 | [NAME] | 666-66-6666 | Tech | C | 2003-01-01 00:00:00 | 1 | 6 | 0.032 | 0.4 | 0.114 | 0.031 | 0.5770000000000001 | 15 | 15 | 30 |  | Manager |  | D
 | 55555 | [NAME] | 555-55-5555 | Tech | B | 2004-01-01 00:00:00 | 1 | 3 | 0.035 | 0.44 | 0.131 | 0.0365 | 0.6425 | 20 | 20 | 40
 | 66666 | [NAME] 6 | 444-44-4444 | Manager | A | 2005-01-01 00:00:00 | 1 | 3 | 0.038 | 0.48 | 0.148 | 0.042 | 0.7080000000000001 | 20 | 20 | 40
 | 77777 | [NAME] 33 | 333-33-3333 | Tech | C | 2006-01-01 00:00:00 | 1 | 4 | 0.023 | 0.28 | 0.063 | 0.0145 | 0.3805000000000001 | 25 | 25 | 50
 | 88888 | [NAME] | 222-22-2222 | General | B | 2007-01-01 00:00:00 | 1 | 1 | 0.026 | 0.32 | 0.08 | 0.02 | 0.4460000000000001 | 25 | 25 | 50
 | 99999 | [NAME] | 111-11-1111 | Tech | A | 2008-01-01 00:00:00 | 1 | 2 | 0.029 | 0.36 | 0.097 | 0.0255 | 0.5115 | 30 | 30 | 60
 | 10101 | [NAME] 9 | 000-00-0000 | Manager | C | 2009-01-01 00:00:00 | 1 | 6 | 0.032 | 0.4 | 0.114 | 0.031 | 0.5770000000000001 | 30 | 30 | 60
 | 11011 | [NAME] 10 | 999-99-10000 | General | C | 2010-01-01 00:00:00 | 1 | 3 | 0.035 | 0.44 | 0.131 | 0.0365 | 0.6425 | 35 | 35 | 70
 | 12121 | [NAME] | 888-88-8889 | General | B | 2011-01-01 00:00:00 | 1 | 3 | 0.038 | 0.48 | 0.148 | 0.042 | 0.7080000000000001 | 35 | 35 | 70
 | 13131 | [NAME] 55 | 777-77-7778 | General | A | 2012-01-01 00:00:00 | 1 | 4 | 0.023 | 0.28 | 0.063 | 0.0145 | 0.3805000000000001 | 40 | 40 | 80
 | 14141 | [NAME] | 666-66-6667 | Tech | C | 2013-01-01 00:00:00 | 1 | 1 | 0.026 | 0.32 | 0.08 | 0.02 | 0.4460000000000001 | 40 | 40 | 80
 | 15151 | [NAME] 13 | 555-55-5556 | Tech | B | 2014-01-01 00:00:00 | 1 | 2 | 0.029 | 0.36 | 0.097 | 0.0255 | 0.5115 | 45 | 45 | 90
 | 16161 | [NAME] 14 | 444-44-4445 | Manager | A | 2015-01-01 00:00:00 | 1 | 6 | 0.032 | 0.4 | 0.114 | 0.031 | 0.5770000000000001 | 45 | 45 | 90
 | 17171 | [NAME] 15 | 333-33-3334 | Tech | C | 2016-01-01 00:00:00 | 1 | 3 | 0.035 | 0.44 | 0.131 | 0.0365 | 0.6425 | 50 | 50 | 100
 | 18181 | [NAME] 16 | 222-22-2223 | General | B | 2017-01-01 00:00:00 | 1 | 3 | 0.038 | 0.48 | 0.148 | 0.042 | 0.7080000000000001 | 50 | 50 | 100
 | 19191 | [NAME] 23 | 111-11-1112 | Tech | A | 2018-01-01 00:00:00 | 1 | 4 | 0.023 | 0.28 | 0.063 | 0.0145 | 0.3805000000000001 | 55 | 55 | 110
 | 20202 | [NAME] 17 | 000-00-0001 | Manager | C | 2019-01-01 00:00:00 | 1 | 1 | 0.026 | 0.32 | 0.08 | 0.02 | 0.4460000000000001 | 55 | 55 | 110
 | 21212 | [NAME] 18 | 999-99-10001 | General | C | 2020-01-01 00:00:00 | 1 | 2 | 0.029 | 0.36 | 0.097 | 0.0255 | 0.5115 | 60 | 60 | 120
 | 22022 | [NAME] 19 | 888-88-8890 | General | B | 2021-01-01 00:00:00 | 1 | 6 | 0.032 | 0.4 | 0.114 | 0.031 | 0.5770000000000001 | 60 | 60 | 120
 | 23232 | [NAME] 20 | 777-77-7779 | General | A | 2022-01-01 00:00:00 | 1 | 3 | 0.035 | 0.44 | 0.131 | 0.0365 | 0.6425 | 65 | 65 | 130
 | 24242 | [NAME] 21 | 666-66-6668 | Tech | C | 2023-01-01 00:00:00 | 1 | 3 | 0.038 | 0.48 | 0.148 | 0.042 | 0.7080000000000001 | 65 | 65 | 130
 | 25252 | [NAME] 24 | 555-55-5557 | Tech | B | 2024-01-01 00:00:00 | 1 | 4 | 0.023 | 0.28 | 0.063 | 0.0145 | 0.3805000000000001 | 70 | 70 | 140