Spreadsheet: 39452d1237607710-if-vlookup-payroll-3
Sheet: Employee Info

 | Employee  ID | Name | Social Security Number | Position | 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 | 2001-01-01 00:00:00 | 1 | 4 | 0.023 | 0.28 | 0.063 | 0.0145 | 0.3805000000000001 |  |  | 0 |  | General |  | A
 | 22222 | [NAME] | 888-88-8888 | General | B | 2002-01-01 00:00:00 | 1 | 1 | 0.026 | 0.32 | 0.08 | 0.02 | 0.4460000000000001 |  |  | 0 |  | Tech |  | B
 | 33333 | [NAME] | 777-77-7777 | General | A | 2003-01-01 00:00:00 | 1 | 2 | 0.029 | 0.36 | 0.097 | 0.0255 | 0.5115 |  |  | 0 |  | A Manager |  | C
 | 44444 | [NAME] | 666-66-6666 | Tech | B | 2004-01-01 00:00:00 | 1 | 6 | 0.032 | 0.4 | 0.114 | 0.031 | 0.5770000000000001 |  |  | 0 |  | Manager |  | D
 | 55555 | [NAME] | 555-55-5555 | Tech | A | 2005-01-01 00:00:00 | 1 | 3 | 0.035 | 0.44 | 0.131 | 0.0365 | 0.6425 |  |  | 0
 | 66666 | [NAME] 6 | 444-44-4444 | Manager | C | 2006-01-01 00:00:00 | 1 | 3 | 0.038 | 0.48 | 0.148 | 0.042 | 0.7080000000000001 |  |  | 0
 | 77777 | [NAME] 33 | 333-33-3333 | Tech | B | 2007-01-01 00:00:00 | 1 | 4 | 0.023 | 0.28 | 0.063 | 0.0145 | 0.3805000000000001 |  |  | 0
 | 88888 | [NAME] | 222-22-2222 | General | A | 2008-01-01 00:00:00 | 1 | 1 | 0.026 | 0.32 | 0.08 | 0.02 | 0.4460000000000001 |  |  | 0
 | 99999 | [NAME] | 111-11-1111 | Tech | C | 2009-01-01 00:00:00 | 1 | 2 | 0.029 | 0.36 | 0.097 | 0.0255 | 0.5115 |  |  | 0
 | 10101 | [NAME] 9 |  | Manager | C |  | 1 | 6 | 0.032 | 0.4 | 0.114 | 0.031 | 0.5770000000000001 |  |  | 0
 | 11011 | [NAME] 10 |  |  |  |  | 1 | 3 | 0.035 | 0.44 | 0.131 | 0.0365 | 0.6425 |  |  | 0
 | 12121 | [NAME] |  |  |  |  | 1 | 3 | 0.038 | 0.48 | 0.148 | 0.042 | 0.7080000000000001 |  |  | 0
 | 13131 | [NAME] 55 |  |  |  |  | 1 | 4 | 0.023 | 0.28 | 0.063 | 0.0145 | 0.3805000000000001 |  |  | 0
 | 14141 | [NAME] |  |  |  |  | 1 | 1 | 0.026 | 0.32 | 0.08 | 0.02 | 0.4460000000000001 |  |  | 0
 | 15151 | [NAME] 13 |  |  |  |  | 1 | 2 | 0.029 | 0.36 | 0.097 | 0.0255 | 0.5115 |  |  | 0
 | 16161 | [NAME] 14 |  |  |  |  | 1 | 6 | 0.032 | 0.4 | 0.114 | 0.031 | 0.5770000000000001 |  |  | 0
 | 17171 | [NAME] 15 |  |  |  |  | 1 | 3 | 0.035 | 0.44 | 0.131 | 0.0365 | 0.6425 |  |  | 0
 | 18181 | [NAME] 16 |  |  |  |  | 1 | 3 | 0.038 | 0.48 | 0.148 | 0.042 | 0.7080000000000001 |  |  | 0
 | 19191 | [NAME] 23 |  |  |  |  | 1 | 4 | 0.023 | 0.28 | 0.063 | 0.0145 | 0.3805000000000001 |  |  | 0
 | 20202 | [NAME] 17 |  |  |  |  | 1 | 1 | 0.026 | 0.32 | 0.08 | 0.02 | 0.4460000000000001 |  |  | 0
 | 21212 | [NAME] 18 |  |  |  |  | 1 | 2 | 0.029 | 0.36 | 0.097 | 0.0255 | 0.5115 |  |  | 0
 | 22022 | [NAME] 19 |  |  |  |  | 1 | 6 | 0.032 | 0.4 | 0.114 | 0.031 | 0.5770000000000001 |  |  | 0
 | 23232 | [NAME] 20 |  |  |  |  | 1 | 3 | 0.035 | 0.44 | 0.131 | 0.0365 | 0.6425 |  |  | 0
 | 24242 | [NAME] 21 |  |  |  |  | 1 | 3 | 0.038 | 0.48 | 0.148 | 0.042 | 0.7080000000000001 |  |  | 0
 | 25252 | [NAME] 24 |  |  |  |  | 1 | 4 | 0.023 | 0.28 | 0.063 | 0.0145 | 0.3805000000000001 |  |  | 0