Spreadsheet: 39218d1237404934-if-vlookup-payroll
Sheet: Pay Stubs

 |  | [Company Name] |  |  |  |  |  |  |  |  | Pay Categories
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 11111 |  |  | Position | Category | [NAME] | Overtime Rate | Double Time Rate
 |  |  |  |  |  |  |  |  |  |  | General | A | 7.5 | 11.25 | 15
 |  | Tax Status |  |  | Position | General | Hours Worked |  |  |  | General | B | 8 | 12 | 16
 |  | Federal Allowance (From W-4) |  |  | Category | C | Overtime Hours |  |  |  | General | C | 8.5 | 12.75 | 17
 |  | Social Security Tax | 0.063 |  | [NAME] | #N/A | Double Time Hours |  |  |  | General | D | 9 | 13.5 | 18
 |  | Medicare Tax | 0.0145 |  | Overtime Rate |  | Sick Hours |  |  |  | Tech | A | 10 | 15 | 20
 |  | Federal Income Tax | 0.28 |  | Double Time Rate |  | Vacations Hours |  |  |  | Tech | B | 11 | 16.5 | 22
 |  | State Tax | 0.023 |  | Insurance Premium |  | Gross Pay |  |  |  | Tech | C | 12 | 18 | 24
 |  |  |  |  |  |  | Net Pay |  |  |  | Tech | D | 13 | 19.5 | 26
 |  |  |  |  |  |  |  |  |  |  | A Manager | A | 12.5 | 18.75 | 25
 |  |  |  |  |  |  |  |  |  |  | A Manager | B | 14 | 21 | 28
 |  | [Company Name] |  |  |  |  |  |  |  |  | A Manager | C | 15.5 | 23.25 | 31
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 22222 |  |  | A Manager | D | 17 | 25.5 | 34
 |  |  |  |  |  |  |  |  |  |  | Manager | A | 15 | 22.5 | 30
 |  | Tax Status |  |  | Position | General | Hours Worked |  |  |  | Manager | B | 17 | 25.5 | 34
 |  | Federal Allowance (From W-4) |  |  | Category | B | Overtime Hours |  |  |  | Manager | C | 19 | 28.5 | 38
 |  | Social Security Tax | 0.063 |  | [NAME] | #N/A | Double Time Pay |  |  |  | Manager | D | 21 | 31.5 | 42
 |  | Medicare Tax | 0.0145 |  | Overtime Rate |  | Sick Hours
 |  | Federal Income Tax | 0.28 |  | Double Time Rate |  | Vacations Hours
 |  | State Tax | 0.023 |  | Insurance Premium |  | Gross Pay
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 33333
 |  | Tax Status |  |  | Position | General | Hours Worked
 |  | Federal Allowance (From W-4) |  |  | Category | A | Overtime Hours
 |  | Social Security Tax | 0.063 |  | [NAME] | #N/A | Double Time Pay
 |  | Medicare Tax | 0.0145 |  | Overtime Rate |  | Sick Hours
 |  | Federal Income Tax | 0.28 |  | Double Time Rate |  | Vacations Hours
 |  | State Tax | 0.023 |  | Insurance Premium |  | Gross Pay
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 44444
 |  | Tax Status |  |  | Position | Tech | Hours Worked
 |  | Federal Allowance (From W-4) |  |  | Category | B | Overtime Hours
 |  | Social Security Tax | 0.063 |  | [NAME] | #N/A | Double Time Pay
 |  | Medicare Tax | 0.0145 |  | Overtime Rate |  | Sick Hours
 |  | Federal Income Tax | 0.28 |  | Double Time Rate |  | Vacations Hours
 |  | State Tax | 0.023 |  | Insurance Premium |  | Gross Pay
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 55555
 |  | Tax Status |  |  | Position | Tech | Hours Worked
 |  | Federal Allowance (From W-4) |  |  | Category | A | Overtime Hours
 |  | Social Security Tax | 0.063 |  | [NAME] | #N/A | Double Time Pay
 |  | Medicare Tax | 0.0145 |  | Overtime Rate |  | Sick Hours
 |  | Federal Income Tax | 0.28 |  | Double Time Rate |  | Vacations Hours
 |  | State Tax | 0.023 |  | Insurance Premium |  | Gross Pay
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] 6 | Employee ID | 66666
 |  | Tax Status |  |  | Position | Manager | Hours Worked
 |  | Federal Allowance (From W-4) |  |  | Category | C | Overtime Hours
 |  | Social Security Tax | 0.063 |  | [NAME] | #N/A | Double Time Pay
 |  | Medicare Tax | 0.0145 |  | Overtime Rate |  | Sick Hours
 |  | Federal Income Tax | 0.28 |  | Double Time Rate |  | Vacations Hours
 |  | State Tax | 0.023 |  | Insurance Premium |  | Gross Pay
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 11111
 |  | Tax Status |  |  | Position | General | Hours Worked
 |  | Federal Allowance (From W-4) |  |  | Category | C | Overtime Hours
 |  | Social Security Tax | 0.063 |  | [NAME] | #N/A | Double Time Pay
 |  | Medicare Tax | 0.0145 |  | Overtime Rate |  | Sick Hours
 |  | Federal Income Tax | 0.28 |  | Double Time Rate |  | Vacations Hours
 |  | State Tax | 0.023 |  | Insurance Premium |  | Gross Pay
 |  |  |  |  |  |  | Net Pay
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 11111
 |  | Tax Status |  |  | Position | General | Hours Worked
 |  | Federal Allowance (From W-4) |  |  | Category | C | Overtime Hours
 |  | Social Security Tax | 0.063 |  | [NAME] | #N/A | Double Time Pay
 |  | Medicare Tax | 0.0145 |  | Overtime Rate |  | Sick Hours
 |  | Federal Income Tax | 0.28 |  | Double Time Rate |  | Vacations Hours
 |  | State Tax | 0.023 |  | Insurance Premium |  | Gross Pay
 |  |  |  |  |  |  | Net Pay