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

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