Spreadsheet: 39550d1237827655-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 | 12345 |  | Key | Position | Category | [NAME] | Overtime Rate | Double Time Rate
 |  |  |  |  |  |  |  |  |  | General-A | General | A | 7.5 | 11.25 | 15
 |  | Tax Status |  |  | Position | General | Regular Hours | 16 |  | General-B | General | B | 8 | 12 | 16
 |  | Federal Allowance (From W-4) |  |  | Category | C | Overtime Hours | 20 |  | General-C | General | C | 8.5 | 12.75 | 17
 |  | Social Security Tax | 0.063 |  | [NAME] | 8.5 | Double Time Hours | 25 |  | General-D | General | D | 9 | 13.5 | 18
 |  | Medicare Tax | 0.0145 |  | Overtime Rate | 12.75 | Sick Hours | 24 |  | Tech-A | Tech | A | 10 | 15 | 20
 |  | Federal Income Tax | 0.28 |  | Double Time Rate | 17 | Vacations Hours | 32 |  | Tech-B | Tech | B | 11 | 16.5 | 22
 |  | State Tax | 0.023 |  | Insurance Premium | 10 | Gross Pay | 1292 |  | Tech-C | Tech | C | 12 | 18 | 24
 |  | Extra Withholding | 10 |  | Total Hours | 85 | Net Pay | 780.394 |  | Tech-D | Tech | D | 13 | 19.5 | 26
 |  |  |  |  |  |  |  |  |  | A Manager-A | A Manager | A | 12.5 | 18.75 | 25
 |  |  |  |  |  |  |  |  |  | A Manager-B | A Manager | B | 14 | 21 | 28
 |  | [Company Name] |  |  |  |  |  |  |  | A Manager-C | 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 | A Manager | D | 17 | 25.5 | 34
 |  |  |  |  |  |  |  |  |  | Manager-A | Manager | A | 15 | 22.5 | 30
 |  | Tax Status |  |  | Position | General | Regular Hours | 16 |  | Manager-B | Manager | B | 17 | 25.5 | 34
 |  | Federal Allowance (From W-4) |  |  | Category | B | Overtime Hours | 16 |  | Manager-C | Manager | C | 19 | 28.5 | 38
 |  | Social Security Tax | 0.063 |  | [NAME] | 8 | Double Time Hours | 16 |  | Manager-D | Manager | D | 21 | 31.5 | 42
 |  | Medicare Tax | 0.0145 |  | Overtime Rate | 12 | Sick Hours | 21
 |  | Federal Income Tax | 0.28 |  | Double Time Rate | 16 | Vacations Hours | 16
 |  | State Tax | 0.023 |  | Insurance Premium | 10 | Gross Pay | 872
 |  | Extra Withholding | 10 |  | Total Hours | 61 | Net Pay | 520.204
 |  | [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 | Regular Hours | 16
 |  | Federal Allowance (From W-4) |  |  | Category | A | Overtime Hours | 16
 |  | Social Security Tax | 0.063 |  | [NAME] | 7.5 | Double Time Hours | 16
 |  | Medicare Tax | 0.0145 |  | Overtime Rate | 11.25 | Sick Hours | 21
 |  | Federal Income Tax | 0.28 |  | Double Time Rate | 15 | Vacations Hours | 16
 |  | State Tax | 0.023 |  | Insurance Premium | 10 | Gross Pay | 817.5
 |  | Extra Withholding | 10 |  | Total Hours | 61 | Net Pay | 486.44125
 |  | [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 | Regular Hours | 16
 |  | Federal Allowance (From W-4) |  |  | Category | C | Overtime Hours | 16
 |  | Social Security Tax | 0.063 |  | [NAME] | 12 | Double Time Hours | 16
 |  | Medicare Tax | 0.0145 |  | Overtime Rate | 18 | Sick Hours | 21
 |  | Federal Income Tax | 0.28 |  | Double Time Rate | 24 | Vacations Hours | 16
 |  | State Tax | 0.023 |  | Insurance Premium | 10 | Gross Pay | 1308
 |  | Extra Withholding | 10 |  | Total Hours | 61 | Net Pay | 790.306
 |  | [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 | Regular Hours | 16
 |  | Federal Allowance (From W-4) |  |  | Category | B | Overtime Hours | 16
 |  | Social Security Tax | 0.063 |  | [NAME] | 11 | Double Time Hours | 16
 |  | Medicare Tax | 0.0145 |  | Overtime Rate | 16.5 | Sick Hours | 21
 |  | Federal Income Tax | 0.28 |  | Double Time Rate | 22 | Vacations Hours | 16
 |  | State Tax | 0.023 |  | Insurance Premium | 10 | Gross Pay | 1199
 |  | Extra Withholding | 10 |  | Total Hours | 61 | Net Pay | 722.7805
 |  | [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 | Regular Hours | 16
 |  | Federal Allowance (From W-4) |  |  | Category | A | Overtime Hours | 16
 |  | Social Security Tax | 0.063 |  | [NAME] | 15 | Double Time Hours | 16
 |  | Medicare Tax | 0.0145 |  | Overtime Rate | 22.5 | Sick Hours | 21
 |  | Federal Income Tax | 0.28 |  | Double Time Rate | 30 | Vacations Hours | 16
 |  | State Tax | 0.023 |  | Insurance Premium | 10 | Gross Pay | 1635
 |  | Extra Withholding | 10 |  | Total Hours | 61 | Net Pay | 992.8824999999999
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] 33 | Employee ID | 77777
 |  | Tax Status |  |  | Position | Tech | Regular Hours | 16
 |  | Federal Allowance (From W-4) |  |  | Category | C | Overtime Hours | 16
 |  | Social Security Tax | 0.063 |  | [NAME] | 12 | Double Time Hours | 16
 |  | Medicare Tax | 0.0145 |  | Overtime Rate | 18 | Sick Hours | 21
 |  | Federal Income Tax | 0.28 |  | Double Time Rate | 24 | Vacations Hours | 16
 |  | State Tax | 0.023 |  | Insurance Premium | 10 | Gross Pay | 1308
 |  | Extra Withholding | 10 |  | Total Hours | 61 | Net Pay | 790.306
 |  | [Company Name]
 |  | Period: | 2009-01-01 00:00:00 | 2009-01-14 00:00:00 | Employee Name | [NAME] | Employee ID | 88888
 |  | Tax Status |  |  | Position | General | Regular Hours | 16
 |  | Federal Allowance (From W-4) |  |  | Category | B | Overtime Hours | 16
 |  | Social Security Tax | 0.063 |  | [NAME] | 8 | Double Time Hours | 16
 |  | Medicare Tax | 0.0145 |  | Overtime Rate | 12 | Sick Hours | 21
 |  | Federal Income Tax | 0.28 |  | Double Time Rate | 16 | Vacations Hours | 16
 |  | State Tax | 0.023 |  | Insurance Premium | 10 | Gross Pay | 872
 |  | Extra Withholding | 10 |  | Total Hours | 61 | Net Pay | 520.204