Spreadsheet: 57334d1257438454-creating-conditional-drop-down-boxes-and-then-searching-for-selections-example
Sheet: VARIABLE TORQUE

 |  |  |  |  |  | Motor Only |  | Add for
 |  |  |  |  |  |  |  | C-D Flange | C-D Flange | Vertical
 |  |  |  |  |  |  | IEEE841 | w/ feet | no feet | D-flange
 |  | Base |  | NEMA | Est. FLA | EPAct | Premium | IM B34- B35 | IM B14-B5 | w/canopy
 | HP | RPM | Encl. | Frame | 460V Only | Efficiency | Efficiency | 2101-2001 | 3611-3001 | V 1
 |  | 1800 | TENV | 143T | 1.5 | xx | xx | xx | xx | xx
 | 1 | 1200 | TENV | 145T | 1.7 | xx | xx | xx | xx | xx
 |  | 900 | TENV | 182T | 2 | xx | xx | xx | xx | xx
 |  | 3600 | TENV | 143T | 2 | xx | xx | xx | xx | xx
 | 1.5 | 1800 | TENV | 145T | 2.1 | xx | xx | xx | xx | xx
 |  | 1200 | TENV | 182T | 2.5 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 184T | 2.9 | xx | xx | xx | xx | xx
 |  | 3600 | TENV | 145T | 2.7 | xx | xx | xx | xx | xx
 | 2 | 1800 | TENV | 145T | 2.8 | xx | xx | xx | xx | xx
 |  | 1200 | TENV | 184T | 3 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 213T | 4 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 182T | 3.7 | xx | xx | xx | xx | xx
 | 3 | 1800 | TENV | 182T | 3.8 | xx | xx | xx | xx | xx
 |  | 1200 | TENV | 213T | 4.7 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 215T | 5.7 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 184T | 6.2 | xx | xx | xx | xx | xx
 | 5 | 1800 | TEFC | 184T | 6.5 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 215T | 8 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 254T | 8.5 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 213T | 9.5 | xx | xx | xx | xx | xx
 | 7.5 | 1800 | TEFC | 213T | 9.8 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 254T | 10 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 256T | 12 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 215T | 12 | xx | xx | xx | xx | xx
 | 10 | 1800 | TEFC | 215T | 12.8 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 256T | 13.1 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 284T | 15.5 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 254T | 18 | xx | xx | xx | xx | xx
 | 15 | 1800 | TEFC | 254T | 19 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 284T | 20.2 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 286T | 22.5 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 256T | 23.5 | xx | xx | xx | xx | xx
 | 20 | 1800 | TEFC | 256T | 25.5 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 286T | 26.3 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 324T | 32 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 284TS | 30 | xx | xx | xx | xx | xx
 | 25 | 1800 | TEFC | 284T | 31.5 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 324T | 33.5 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 326T | 39 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 286TS | 36 | xx | xx | xx | xx | xx
 | 30 | 1800 | TEFC | 286T | 37 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 326T | 38 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 364T | 41 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 324TS | 47.5 | xx | xx | xx | xx | xx
 | 40 | 1800 | TEFC | 324T | 50 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 364T | 51 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 365T | 53.5 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 326TS | 57.5 | xx | xx | xx | xx | xx
 | 50 | 1800 | TEFC | 326T | 61 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 365T | 65 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 404T | 69 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 364TS | 70.5 | xx | xx | xx | xx | xx
 | 60 | 1800 | TEFC | 364T | 72 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 404T | 74.5 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 405T | 81 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 365TS | 87 | xx | xx | xx | xx | xx
 | 75 | 1800 | TEFC | 365T | 89 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 405T | 92.5 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 444T | 93 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 405TS | 110 | xx | xx | xx | xx | xx
 | 100 | 1800 | TEFC | 405T | 114 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 444T | 119 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 445T | 133 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 444TS | 137 | xx | xx | xx | xx | xx
 | 125 | 1800 | TEFC | 444T | 142 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 445T | 152 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 445T | 169 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 445TS | 167 | xx | xx | xx | xx | xx
 | 150 | 1800 | TEFC | 445T | 172 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 445T | 182 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 447/9T | 206 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 445TS | 222 | xx | xx | xx | xx | xx
 | 200 | 1800 | TEFC | 445T | 225 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 447/9T | 243 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 447/9T | 270 | xx | xx | xx | xx | xx
 |  | 3600 | TEFC | 447/9TS | 280 | xx | xx | xx | xx | xx
 | 250 | 1800 | TEFC | 447/9T | 290 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 447/9T | 300 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 447/9T | 330 | xx | xx | xx | xx | xx
 | 300 | 3600 | TEFC | 447/9TS | 330 | xx | xx | xx | xx | xx
 |  | 1800 | TEFC | 447/9T | 338 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 447/9T | 360 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 5013 | 410 | xx | xx | xx | xx | xx
 | 350 | 3600 | TEFC | 447/9TS | 385 | xx | xx | xx | xx | xx
 |  | 1800 | TEFC | 449T | 395 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 5011 | 410 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 5013 | 458 | xx | xx | xx | xx | xx
 | 400 | 3600 | TEFC | 5011S | 432 | xx | xx | xx | xx | xx
 |  | 1800 | TEFC | 449T | 448 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 5011 | 468 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 5013 | 525 | xx | xx | xx | xx | xx
 | 450 | 1800 | TEFC | 447/9T | 515 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 5013 | 525 | xx | xx | xx | xx | xx
 | 500 | 1800 | TEFC | 5011 | 555 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 5013 | 580 | xx | xx | xx | xx | xx
 | 600 | 1800 | TEFC | 5011 | 655 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 5013 |  | xx | xx | xx | xx | xx
 | 700 | 1800 | TEFC | 5013 | 800 | xx | xx | xx | xx | xx