Spreadsheet: 856157d1705509306-formula-for-finding-a-specific-value-in-a-table-based-on-2-inputs-motor-list
Sheet: Table Look Up Sheet

Rockwell / [NAME] [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | INDEX | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  |  |  | HP | 115 | 200 | 208 | 230 | 460 |  | 1 | 2 | 3 | 4
 | Starter Size |  |  |  |  |  | Starter Sizes | [NAME] | [NAME] | Index |  |  | Setting | MCP Continous Amp Rating |  |  |  |  |  |  |  |  | Setting |  | MCP Setting | MCP Index |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Take clear picture of nameplate.
FLA | 1 | 2 | 3 | 4 | 5 |  | Size 1 | 10 | 27 | 2 |  | INDEX |  | 3 | 7 | 15 | 30 | 50 | 100 | 150 | 175 | 250 |  |  | A | 2 |  | 0.5 | 4.4 | 2.5 | 2.4 | 2.2 | 1.1 |  |  |  |  |  |  |  | Where is the device fed from? Provide equipment and circuit number.
W10 | 0.19 |  |  |  |  |  | [NAME] | 25 | 45 | 3 |  | 2 | A | 12 | 28 | 45 | 90 | 150 | 300 | 750 | 875 | 1250 | A |  | B | 3 |  | 0.75 | 6.4 | 3.7 | 3.5 | 3.2 | 1.6 |  |  |  |  |  |  |  | Take picture of field starter / bucket showing the breaker / fuse, contactor and overload. The fuse / breaker model and settings, the contactor size and the overload setting or heater number must be readable.
W11 | 0.21 |  |  |  |  |  | Size 3 | 50 | 90 | 4 |  | 3 | B | 15 | 34 | 60 | 120 | 200 | 400 | 844 | 984 | 1406 | B |  | C | 4 |  | 1 | 8.4 | 4.8 | 4.6 | 4.2 | 2.1 |  |  |  |  |  |  |  | Is a field disconnect installed between the feeder or branch
W12 | 0.23 |  |  |  |  |  | [NAME] | 100 | 135 | 5 |  | 4 | C | 17 | 40 | 75 | 150 | 250 | 500 | 938 | 1094 | 1563 | C |  | D | 5 |  | 1.5 | 12 | 6.9 | 6.6 | 6 | 3 |  | A | D | G | J
W13 | 0.25 |  |  |  |  |  | Size 5 | 200 | 270 | 6 |  | 5 | D | 20 | 46 | 90 | 180 | 300 | 600 | 1031 | 1203 | 1719 | D |  | E | 6 |  | 2 | 13.6 | 7.8 | 7.5 | 6.8 | 3.4 |  | B | E | H | K
W14 | 0.28 |  |  |  |  |  |  |  |  |  |  | 6 | E | 23 | 53 | 105 | 210 | 350 | 700 | 1125 | 1313 | 1875 | E |  | F | 7 |  | 3 |  | 11 | 10.6 | 9.6 | 4.8 |  | C | F | I | L |  |  | Input | 2
W15 | 0.3 |  |  |  |  |  |  |  |  |  |  | 7 | F | 25 | 59 | 120 | 240 | 400 | 800 | 1219 | 1422 | 2031 | F |  | G | 8 |  | 5 |  | 17.5 | 16.7 | 15.2 | 7.6
W16 | 0.33 |  |  |  |  |  |  |  |  |  |  | 8 | G | 28 | 65 | 135 | 270 | 450 | 900 | 1313 | 1531 | 2188 | G |  | H | 9 |  | 7.5 |  | 25.3 | 24.2 | 22 | 11
W17 | 0.36 |  |  |  |  |  |  |  |  |  |  | 9 | H | 30 | 71 | 150 | 300 | 500 | 1000 | 1406 | 1641 | 2344 | H |  | I | 10 |  | 10 |  | 32.2 | 30.8 | 28 | 14
W18 | 0.4 |  |  |  |  |  |  |  |  |  |  | 10 | I | 33 | 77 | 165 | 330 | 550 | 1100 | 1500 | 1750 | 2500 | I |  |  |  |  | 15 |  | 48.3 | 46.2 | 42 | 21 |  |  |  |  |  |  | 0
W19 | 0.44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 62.1 | 59.4 | 54 | 27 |  |  |  |  |  |  | 0
W20 | 0.49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 78.2 | 74.8 | 68 | 34 |  |  |  |  |  |  | 0
W21 | 0.53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 92 | 88 | 80 | 40 |  |  |  |  |  |  | 0
[NAME] | 0.58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MCP CA Rating | MCP CA Index |  | 40 |  | 120 | 114 | 104 | 52 |  |  |  |  |  |  | D
W23 | 0.64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 |  | 50 |  | 150 | 143 | 130 | 65 |  |  |  |  |  |  | E
W24 | 0.7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 3 |  | 60 |  | 177 | 169 | 154 | 77 |  |  |  |  |  |  | F
W25 | 0.77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 4 |  | 75 |  | 221 | 211 | 192 | 96
W26 | 0.85 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 5 |  | 100 |  | 285 | 273 | 248 | 124
[NAME] | 0.93 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 6 |  | 125 |  | 359 | 343 | 312 | 156
W28 | 1.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 7 |  | 150 |  | 414 | 396 | 360 | 180
W29 | 1.12 |  |  |  | 77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 | 8 |  | 200 |  | 552 | 528 | 480 | 240
W30 | 1.23 |  |  |  | 83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 250 |  |  |  |  | 302
W31 | 1.35 |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 300 |  |  |  |  | 361
W32 | 1.48 |  |  |  | 98 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 350 |  |  |  |  | 414
W33 | 1.62 |  |  |  | 107
[NAME] | 1.79 |  |  |  | 116
W35 | 1.97 |  |  |  | 126
W36 | 2.18 |  |  |  | 138
W37 | 2.4 |  |  |  | 150
W38 | 2.65 |  |  |  | 164
W39 | 2.92 |  |  |  | 178
W40 | 3.23 |  |  |  | 194 |  |  |  |  |  |  |  | A | B | C | D | E | F | G | H | I
W41 | 3.56 |  |  |  | 212 |  |  |  |  |  |  | 3 | 12 | 15 | 17 | 20 | 23 | 25 | 28 | 30 | 33
W42 | 3.93 |  |  |  | 232 |  |  |  |  |  |  | 7 | 28 | 34 | 40 | 46 | 53 | 59 | 65 | 71 | 77
W43 | 4.3 |  |  |  | 254 |  |  |  |  |  |  | 15 | 45 | 60 | 75 | 90 | 105 | 120 | 135 | 150 | 165
W44 | 4.71 |  |  |  | 270 |  |  |  |  |  |  | 30 | 90 | 120 | 150 | 180 | 210 | 240 | 270 | 300 | 330
W45 | 5.16 |  |  |  |  |  |  |  |  |  |  | 50 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550
W46 | 5.66 |  |  |  |  |  |  |  |  |  |  | 100 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100
W47 | 6.28 |  |  |  |  |  |  |  |  |  |  | 150 | 750 | 844 | 938 | 1031 | 1125 | 1219 | 1313 | 1406 | 1500
[NAME] | 6.94 |  |  |  |  |  |  |  |  |  |  |  | 875 | 984 | 1094 | 1203 | 1313 | 1422 | 1531 | 1641 | 1750
[NAME] | 7.71 |  |  |  |  |  |  |  |  |  |  |  | 1250 | 1406 | 1563 | 1719 | 1875 | 2031 | 2188 | 2344 | 2500
W50 | 8.45 | 8.56
W51 | 9.29 | 9.4
W52 | 10.3 | 10.4
W53 | 11.4 | 11.5
W54 | 12.5 | 12.6
W55 | 13.7 | 13.8
W56 | 15 | 15.1
W57 | 16.3 | 16.4
W58 | 17.7 | 17.9
W59 | 19.3 | 19.5
W60 | 20.9 | 21.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:V12,9,10) |  |  | returns the value of a cell in a table based on the column and row number
W61 | 22.7 | 23 | 25.4
W62 | 24.7 | 25.1 | 27.8 |  |  |  |  |  |  |  |  |  |  |  |  | MATCH(938,P4:P12,0) |  |  | returns the position of a cell in a row or column.
W63 | 26.9 | 27.3 | 30.5
W64 | 29.2 | 29.7 | 33.5 | 35 |  |  |  |  |  |  |  |  |  |  | Combined, the two formulas can look up and return the value of a cell in a table based on vertical and horizontal criteria.  For short, this is referred to as just the Index Match function.
W65 |  | 31.5 | 37 | 38.5
W66 |  | 34.5 | 40.5 | 42 |  |  |  |  |  |  |  |  |  |  |  | Column | Set to | [NAME]
W67 |  | 37.5 | 44.5 | 46 |  |  |  |  |  |  |  |  |  | 30 | G | 8 | 270 | 156 | FAIL
[NAME] |  | 41 | 48.5 | 51
W69 |  | 44 | 53 | 56 |  |  |  |  |  |  |  |  |  | X Plug
W70 |  | 47 | 59 | 61
W71 |  |  | 64 | 66
W72 |  |  | 69 | 71
W73 |  |  | 73 | 76
[NAME] |  |  | 77 | 82
W75 |  |  | 81 | 88
[NAME] |  |  | 85 | 94
W77 |  |  | 90 | 100
W78 |  |  |  | 106
W79 |  |  |  | 113
wao |  |  |  | 120
W81 |  |  |  | 128
W82 |  |  |  | 135