Spreadsheet: 92821d1292357886-lookup-question-with-multiple-criteria-example2
Sheet: Tax Bracket

Single Persons Biweekly Payroll Period
At Least | But Less Than | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
0 | 240 | 0 | 0 | 0 | 0 | 0 | 0 | 0
240 | 245 | 1 | 0 | 0 | 0 | 0 | 0 | 0
245 | 250 | 1 | 0 | 0 | 0 | 0 | 0 | 0
250 | 260 | 2 | 0 | 0 | 0 | 0 | 0 | 0
260 | 270 | 3 | 0 | 0 | 0 | 0 | 0 | 0
270 | 280 | 4 | 0 | 0 | 0 | 0 | 0 | 0
280 | 290 | 5 | 0 | 0 | 0 | 0 | 0 | 0
290 | 300 | 6 | 0 | 0 | 0 | 0 | 0 | 0
300 | 310 | 7 | 0 | 0 | 0 | 0 | 0 | 0
310 | 320 | 8 | 0 | 0 | 0 | 0 | 0 | 0
320 | 330 | 9 | 0 | 0 | 0 | 0 | 0 | 0
330 | 340 | 10 | 0 | 0 | 0 | 0 | 0 | 0
340 | 350 | 11 | 0 | 0 | 0 | 0 | 0 | 0
350 | 360 | 12 | 0 | 0 | 0 | 0 | 0 | 0
360 | 370 | 13 | 0 | 0 | 0 | 0 | 0 | 0
370 | 380 | 14 | 0 | 0 | 0 | 0 | 0 | 0
380 | 390 | 15 | 1 | 0 | 0 | 0 | 0 | 0
390 | 400 | 16 | 2 | 0 | 0 | 0 | 0 | 0
400 | 410 | 17 | 3 | 0 | 0 | 0 | 0 | 0
410 | 420 | 19 | 4 | 0 | 0 | 0 | 0 | 0
420 | 430 | 20 | 5 | 0 | 0 | 0 | 0 | 0
430 | 440 | 22 | 6 | 0 | 0 | 0 | 0 | 0
440 | 450 | 23 | 7 | 0 | 0 | 0 | 0 | 0
450 | 460 | 25 | 8 | 0 | 0 | 0 | 0 | 0
460 | 470 | 26 | 9 | 0 | 0 | 0 | 0 | 0
470 | 480 | 28 | 10 | 0 | 0 | 0 | 0 | 0
480 | 490 | 29 | 11 | 0 | 0 | 0 | 0 | 0
490 | 500 | 31 | 12 | 0 | 0 | 0 | 0 | 0
500 | 520 | 33 | 14 | 0 | 0 | 0 | 0 | 0
520 | 540 | 36 | 16 | 2 | 0 | 0 | 0 | 0
540 | 560 | 39 | 18 | 4 | 0 | 0 | 0 | 0
560 | 580 | 42 | 21 | 6 | 0 | 0 | 0 | 0
580 | 600 | 45 | 24 | 8 | 0 | 0 | 0 | 0
600 | 620 | 48 | 27 | 10 | 0 | 0 | 0 | 0
620 | 640 | 51 | 30 | 12 | 0 | 0 | 0 | 0
640 | 660 | 54 | 33 | 14 | 0 | 0 | 0 | 0
660 | 680 | 57 | 36 | 16 | 2 | 0 | 0 | 0
680 | 700 | 60 | 39 | 18 | 4 | 0 | 0 | 0
700 | 720 | 63 | 42 | 21 | 6 | 0 | 0 | 0
720 | 740 | 66 | 45 | 24 | 8 | 0 | 0 | 0
740 | 760 | 69 | 48 | 27 | 10 | 0 | 0 | 0
760 | 780 | 72 | 51 | 30 | 12 | 0 | 0 | 0
780 | 800 | 75 | 54 | 33 | 14 | 0 | 0 | 0
800 | 820 | 78 | 57 | 36 | 16 | 2 | 0 | 0
820 | 840 | 81 | 60 | 39 | 18 | 4 | 0 | 0
840 | 860 | 84 | 63 | 42 | 21 | 6 | 0 | 0
860 | 880 | 87 | 66 | 45 | 24 | 8 | 0 | 0
880 | 900 | 90 | 69 | 48 | 27 | 10 | 0 | 0
900 | 920 | 93 | 72 | 51 | 30 | 12 | 0 | 0
920 | 940 | 96 | 75 | 54 | 33 | 14 | 0 | 0
940 | 960 | 99 | 78 | 57 | 36 | 16 | 2 | 0
960 | 980 | 102 | 81 | 60 | 39 | 18 | 4 | 0
980 | 1000 | 105 | 84 | 63 | 42 | 21 | 6 | 0
1000 | 1020 | 108 | 87 | 66 | 45 | 24 | 8 | 0
1020 | 1040 | 111 | 90 | 69 | 48 | 27 | 10 | 0
1040 | 1060 | 114 | 93 | 72 | 51 | 30 | 12 | 0
1060 | 1080 | 117 | 96 | 75 | 54 | 33 | 14 | 0
1080 | 1100 | 120 | 99 | 78 | 57 | 36 | 16 | 2
1100 | 1120 | 123 | 102 | 81 | 60 | 39 | 18 | 4
1120 | 1140 | 126 | 105 | 84 | 63 | 42 | 21 | 6
1140 | 1160 | 129 | 108 | 87 | 66 | 45 | 24 | 8
1160 | 1180 | 132 | 111 | 90 | 69 | 48 | 27 | 10
1180 | 1200 | 135 | 114 | 93 | 72 | 51 | 30 | 12
1200 | 1220 | 138 | 117 | 96 | 75 | 54 | 33 | 14
1220 | 1240 | 141 | 120 | 99 | 78 | 57 | 36 | 16
1240 | 1260 | 144 | 123 | 102 | 81 | 60 | 39 | 18
1260 | 1280 | 147 | 126 | 105 | 84 | 63 | 42 | 21
1280 | 1300 | 150 | 129 | 108 | 87 | 66 | 45 | 24
1300 | 1320 | 153 | 132 | 111 | 90 | 69 | 48 | 27
1320 | 1340 | 156 | 135 | 114 | 93 | 72 | 51 | 30
1340 | 1360 | 159 | 138 | 117 | 96 | 75 | 54 | 33
1360 | 1380 | 162 | 141 | 120 | 99 | 78 | 57 | 36
1380 | 1400 | 166 | 144 | 123 | 102 | 81 | 60 | 39
1400 | 1420 | 171 | 147 | 126 | 105 | 84 | 63 | 42
1420 | 1440 | 176 | 150 | 129 | 108 | 87 | 66 | 45
1440 | 1460 | 181 | 153 | 132 | 111 | 90 | 69 | 48
1460 | 1480 | 186 | 156 | 135 | 114 | 93 | 72 | 51
1480 | 1500 | 191 | 159 | 138 | 117 | 96 | 75 | 54
1500 | 1520 | 196 | 162 | 141 | 120 | 99 | 78 | 57
1520 | 1540 | 201 | 165 | 144 | 123 | 102 | 81 | 60
1540 | 1560 | 206 | 170 | 147 | 126 | 105 | 84 | 63
1560 | 1580 | 211 | 175 | 150 | 129 | 108 | 87 | 66
1580 | 1600 | 216 | 180 | 153 | 132 | 111 | 90 | 69
1600 | 1620 | 221 | 185 | 156 | 135 | 114 | 93 | 72
1620 | 1640 | 226 | 190 | 159 | 138 | 117 | 96 | 75
1640 | 1660 | 231 | 195 | 162 | 141 | 120 | 99 | 78
1660 | 1680 | 236 | 200 | 165 | 144 | 123 | 102 | 81
1680 | 1700 | 241 | 205 | 170 | 147 | 126 | 105 | 84
1700 | 1720 | 246 | 210 | 175 | 150 | 129 | 108 | 87
1720 | 1740 | 251 | 215 | 180 | 153 | 132 | 111 | 90
1740 | 1760 | 256 | 220 | 185 | 156 | 135 | 114 | 93
1760 | 1780 | 261 | 225 | 190 | 159 | 138 | 117 | 96
1780 | 1800 | 266 | 230 | 195 | 162 | 141 | 120 | 99
1800 | 1820 | 271 | 235 | 200 | 165 | 144 | 123 | 102
1820 | 1840 | 276 | 240 | 205 | 170 | 147 | 126 | 105
1840 | 1860 | 281 | 245 | 210 | 175 | 150 | 129 | 108
1860 | 1880 | 286 | 250 | 215 | 180 | 153 | 132 | 111
1880 | 1900 | 291 | 255 | 220 | 185 | 156 | 135 | 114
1900 | 1920 | 296 | 260 | 225 | 190 | 159 | 138 | 117
1920 | 1940 | 301 | 265 | 230 | 195 | 162 | 141 | 120
1940 | 1960 | 306 | 270 | 235 | 200 | 165 | 144 | 123
1960 | 1980 | 311 | 275 | 240 | 205 | 170 | 147 | 126
1980 | 2000 | 316 | 280 | 245 | 210 | 175 | 150 | 129
2000 | 2020 | 321 | 285 | 250 | 215 | 180 | 153 | 132
2020 | 2040 | 326 | 290 | 255 | 220 | 185 | 156 | 135
2040 | 2060 | 331 | 295 | 260 | 225 | 190 | 159 | 138
2060 | 2080 | 336 | 300 | 265 | 230 | 195 | 162 | 141
2080 | 2100 | 341 | 305 | 270 | 235 | 200 | 165 | 144
Married Persons Biweekly Payroll Period
At Least | But Less Than | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
0 | 540 | 0 | 0 | 0 | 0 | 0 | 0 | 0
540 | 560 | 2 | 0 | 0 | 0 | 0 | 0 | 0
560 | 580 | 4 | 0 | 0 | 0 | 0 | 0 | 0
580 | 600 | 6 | 0 | 0 | 0 | 0 | 0 | 0
600 | 620 | 8 | 0 | 0 | 0 | 0 | 0 | 0
620 | 640 | 10 | 0 | 0 | 0 | 0 | 0 | 0
640 | 660 | 12 | 0 | 0 | 0 | 0 | 0 | 0
660 | 680 | 14 | 0 | 0 | 0 | 0 | 0 | 0
680 | 700 | 16 | 2 | 0 | 0 | 0 | 0 | 0
700 | 720 | 18 | 4 | 0 | 0 | 0 | 0 | 0
720 | 740 | 20 | 6 | 0 | 0 | 0 | 0 | 0
740 | 760 | 22 | 8 | 0 | 0 | 0 | 0 | 0
760 | 780 | 24 | 10 | 0 | 0 | 0 | 0 | 0
780 | 800 | 26 | 12 | 0 | 0 | 0 | 0 | 0
800 | 820 | 28 | 14 | 0 | 0 | 0 | 0 | 0
820 | 840 | 30 | 16 | 2 | 0 | 0 | 0 | 0
840 | 860 | 32 | 18 | 4 | 0 | 0 | 0 | 0
860 | 880 | 34 | 20 | 6 | 0 | 0 | 0 | 0
880 | 900 | 36 | 22 | 8 | 0 | 0 | 0 | 0
900 | 920 | 38 | 24 | 10 | 0 | 0 | 0 | 0
920 | 940 | 40 | 26 | 12 | 0 | 0 | 0 | 0
940 | 960 | 43 | 28 | 14 | 0 | 0 | 0 | 0
960 | 980 | 46 | 30 | 16 | 2 | 0 | 0 | 0
980 | 1000 | 49 | 32 | 18 | 4 | 0 | 0 | 0
1000 | 1020 | 52 | 34 | 20 | 6 | 0 | 0 | 0
1020 | 1040 | 55 | 36 | 22 | 8 | 0 | 0 | 0
1040 | 1060 | 58 | 38 | 24 | 10 | 0 | 0 | 0
1060 | 1080 | 61 | 40 | 26 | 12 | 0 | 0 | 0
1080 | 1100 | 64 | 42 | 28 | 14 | 0 | 0 | 0
1100 | 1120 | 67 | 45 | 30 | 16 | 2 | 0 | 0
1120 | 1140 | 70 | 48 | 32 | 18 | 4 | 0 | 0
1140 | 1160 | 73 | 51 | 34 | 20 | 6 | 0 | 0
1160 | 1180 | 76 | 54 | 36 | 22 | 8 | 0 | 0
1180 | 1200 | 79 | 57 | 38 | 24 | 10 | 0 | 0
1200 | 1220 | 82 | 60 | 40 | 26 | 12 | 0 | 0
1220 | 1240 | 85 | 63 | 42 | 28 | 14 | 2 | 0
1240 | 1260 | 88 | 66 | 45 | 30 | 16 | 4 | 0
1260 | 1280 | 91 | 69 | 48 | 32 | 18 | 6 | 0
1280 | 1300 | 94 | 72 | 51 | 34 | 20 | 8 | 0
1300 | 1320 | 97 | 75 | 54 | 36 | 22 | 10 | 0
1320 | 1340 | 100 | 78 | 57 | 38 | 24 | 12 | 0
1340 | 1360 | 103 | 81 | 60 | 40 | 26 | 14 | 0
1360 | 1380 | 106 | 84 | 63 | 42 | 28 | 16 | 0
1380 | 1400 | 109 | 87 | 66 | 45 | 30 | 18 | 2
1400 | 1420 | 112 | 90 | 69 | 48 | 32 | 20 | 4
1420 | 1440 | 115 | 93 | 72 | 51 | 34 | 22 | 6
1440 | 1460 | 118 | 96 | 75 | 54 | 36 | 24 | 8
1460 | 1480 | 121 | 99 | 78 | 57 | 38 | 26 | 10
1480 | 1500 | 124 | 102 | 81 | 60 | 40 | 28 | 12
1500 | 1520 | 127 | 105 | 84 | 63 | 42 | 30 | 14
1520 | 1540 | 130 | 108 | 87 | 66 | 45 | 32 | 16
1540 | 1560 | 133 | 111 | 90 | 69 | 48 | 34 | 18
1560 | 1580 | 136 | 114 | 93 | 72 | 51 | 36 | 20
1580 | 1600 | 139 | 117 | 96 | 75 | 54 | 38 | 22
1600 | 1620 | 142 | 120 | 99 | 78 | 57 | 40 | 24
1620 | 1640 | 145 | 123 | 102 | 81 | 60 | 42 | 26
1640 | 1660 | 148 | 126 | 105 | 84 | 63 | 45 | 28
1660 | 1680 | 151 | 129 | 108 | 87 | 66 | 48 | 30
1680 | 1700 | 154 | 132 | 111 | 90 | 69 | 51 | 32
1700 | 1720 | 157 | 135 | 114 | 93 | 72 | 54 | 34
1720 | 1740 | 160 | 138 | 117 | 96 | 75 | 57 | 36
1740 | 1760 | 163 | 141 | 120 | 99 | 78 | 60 | 38
1760 | 1780 | 166 | 144 | 123 | 102 | 81 | 63 | 40
1780 | 1800 | 169 | 147 | 126 | 105 | 84 | 66 | 42
1800 | 1820 | 172 | 150 | 129 | 108 | 87 | 69 | 45
1820 | 1840 | 175 | 153 | 132 | 111 | 90 | 72 | 48
1840 | 1860 | 178 | 156 | 135 | 114 | 93 | 75 | 51
1860 | 1880 | 181 | 159 | 138 | 117 | 96 | 78 | 54
1880 | 1900 | 184 | 162 | 141 | 120 | 99 | 81 | 57
1900 | 1920 | 187 | 165 | 144 | 123 | 102 | 84 | 60
1920 | 1940 | 190 | 168 | 147 | 126 | 105 | 87 | 63
1940 | 1960 | 193 | 171 | 150 | 129 | 108 | 90 | 66
1960 | 1980 | 196 | 174 | 153 | 132 | 111 | 93 | 69
1980 | 2000 | 199 | 177 | 156 | 135 | 114 | 96 | 72
2000 | 2020 | 202 | 180 | 159 | 138 | 117 | 99 | 75
2020 | 2040 | 205 | 183 | 162 | 141 | 120 | 102 | 78
2040 | 2060 | 208 | 186 | 165 | 144 | 123 | 105 | 81
2060 | 2080 | 211 | 189 | 168 | 147 | 126 | 108 | 84
2080 | 2100 | 214 | 192 | 171 | 150 | 129 | 111 | 87
2100 | 2120 | 217 | 195 | 174 | 153 | 132 | 114 | 90
2120 | 2140 | 220 | 198 | 177 | 156 | 135 | 117 | 93
2140 | 2160 | 223 | 201 | 180 | 159 | 138 | 120 | 96
2160 | 2180 | 226 | 204 | 183 | 162 | 141 | 123 | 99
2180 | 2200 | 229 | 207 | 186 | 165 | 144 | 126 | 102
2200 | 2220 | 232 | 210 | 189 | 168 | 147 | 129 | 105
2220 | 2240 | 235 | 213 | 192 | 171 | 150 | 132 | 108
2240 | 2260 | 238 | 216 | 195 | 174 | 153 | 135 | 111
2260 | 2280 | 241 | 219 | 198 | 177 | 156 | 138 | 114
2280 | 2300 | 244 | 222 | 201 | 180 | 159 | 141 | 117
2300 | 2320 | 247 | 225 | 204 | 183 | 162 | 144 | 120
2320 | 2340 | 250 | 228 | 207 | 186 | 165 | 147 | 123
2340 | 2360 | 253 | 231 | 210 | 189 | 168 | 150 | 126
2360 | 2380 | 256 | 234 | 213 | 192 | 171 | 153 | 129
2380 | 2400 | 259 | 237 | 216 | 195 | 174 | 156 | 132
2400 | 2420 | 262 | 240 | 219 | 198 | 177 | 159 | 135
2420 | 2440 | 265 | 243 | 222 | 201 | 180 | 162 | 138
2440 | 2460 | 268 | 246 | 225 | 204 | 183 | 165 | 141
2460 | 2480 | 271 | 249 | 228 | 207 | 186 | 168 | 144
2480 | 2500 | 274 | 252 | 231 | 210 | 189 | 171 | 147
2500 | 2520 | 277 | 255 | 234 | 213 | 192 | 174 | 150
2520 | 2540 | 280 | 258 | 237 | 216 | 195 | 177 | 153
2540 | 2560 | 283 | 261 | 240 | 219 | 198 | 180 | 156
2560 | 2580 | 286 | 264 | 243 | 222 | 201 | 183 | 159
2580 | 2600 | 289 | 267 | 246 | 225 | 204 | 186 | 162
2600 | 2620 | 292 | 270 | 249 | 228 | 207 | 189 | 165
2620 | 2640 | 295 | 273 | 252 | 231 | 210 | 192 | 168
2640 | 2660 | 298 | 276 | 255 | 234 | 213 | 195 | 171
2660 | 2680 | 301 | 279 | 258 | 237 | 216 | 198 | 174
2680 | 2700 | 304 | 282 | 261 | 240 | 219 | 201 | 177