Spreadsheet: 454447d1459847426-vlookup-not-working-for-me-major-project
Sheet: Employee Tax

Employee Tax Analysis
Employee ID | First Name | Last Name | Position | Gross Pay | Tax Withheld | Tax Amount | Owe/Refund | Tax Status |  |  |  |  | Tax Withheld
46 | [NAME] | Magenta | Manager | 43395 |  |  |  |  |  |  |  |  | Position | Tax Withheld
47 | [NAME] | River | Manager | 77614 |  |  |  |  |  |  |  |  | Manager | 0.25
49 | [NAME] | Great | Manager | 82825 |  |  |  |  |  |  |  |  | Sales | 0.1
69 | [NAME] | Great | Manager | 110303 |  |  |  |  |  |  |  |  | Office | 0.1
70 | [NAME] | Dark | Manager | 51063 |  |  |  |  |  |  |  |  | Production | 0.1
83 | [NAME] | Small | Manager | 79045
6 | [NAME] | Smallhand | Sales | 48375 |  |  |  |  |  |  |  |  | Tax Rate
13 | Janice | Dark | Sales | 29100 |  |  |  |  |  |  |  |  | From | To | Rate
20 | Cecile | Great | Sales | 25620 |  |  |  |  |  |  |  |  | 0 | 29999.99 | 0.1
24 | Janice | Smallhand | Sales | 36015 |  |  |  |  |  |  |  |  | 30000 | 49999.99 | 0.15
44 | [NAME] | Dark | Sales | 32460 |  |  |  |  |  |  |  |  | 50000 | 74999.99 | 0.2
50 | Al | Dark | Sales | 51870 |  |  |  |  |  |  |  |  | 75000 | 99999.99 | 0.25
67 | [NAME] | Pink | Sales | 62520 |  |  |  |  |  |  |  |  | 100000 |  | 0.3
78 | Janice | Small | Sales | 21570
88 | [NAME] | Pale | Sales | 35670
96 | Joel | Magenta | Sales | 46260
7 | Joel | Lake | Office | 30786
23 | [NAME] | Green | Office | 29840
28 | Darcy | Sharpeye | Office | 29280
35 | [NAME] | Green | Office | 29560
51 | [NAME] | Smith | Office | 26712
79 | Joel | Magenta | Office | 25194
84 | [NAME] | Green | Office | 22784
85 | [NAME] | Green | Office | 23936
93 | [NAME] | Lake | Office | 23552
97 | Adam | Smallhand | Office | 23168
4 | Adam | Magenta | Production | 37900
5 | Elis | River | Production | 34868
10 | [NAME] | Lake | Production | 33836
12 | [NAME] | Oak | Production | 33054
16 | Joel | River | Production | 32886
34 | Fred | Dark | Production | 32400
18 | Darcy | Smallhand | Production | 32130
14 | [NAME] | River | Production | 31836
21 | Cecile | Sharpeye | Production | 31800
29 | [NAME] | Grey | Production | 31680
33 | Janice | Pink | Production | 31040
30 | [NAME] | White | Production | 30440
31 | Joel | Oak | Production | 30120
36 | Darcy | River | Production | 29800
26 | [NAME] | Sharpeye | Production | 29760
39 | [NAME] | Smallhand | Production | 29640
25 | Joel | White | Production | 29600
57 | Janice | Smith | Production | 28944
54 | [NAME] | Dark | Production | 28260
43 | [NAME] | Sharpeye | Production | 28044
41 | [NAME] | Finger | Production | 28008
64 | [NAME] | Great | Production | 27812
65 | [NAME] | Great | Production | 27166
53 | Al | Bigleg | Production | 27072
74 | [NAME] | Dark | Production | 26996
76 | [NAME] | Small | Production | 26996
72 | Elis | Smith | Production | 26894
63 | Janice | Lake | Production | 26758
77 | Fred | Small | Production | 26724
66 | [NAME] | Grey | Production | 26724
55 | Al | Finger | Production | 26676
60 | [NAME] | Grey | Production | 26656
61 | Al | Magenta | Production | 26486
75 | Darcy | Dark | Production | 26044
45 | Barb | Smith | Production | 25596
73 | [NAME] | Magenta | Production | 25296
94 | [NAME] | Pale | Production | 25152
86 | [NAME] | Lake | Production | 24832
91 | [NAME] | Lake | Production | 24800
92 | [NAME] | Green | Production | 24800
99 | Darcy | Pale | Production | 24544
95 | Joel | Pale | Production | 24160