Spreadsheet: 28593d1222909270-vlookup-information-in-a-table-and-round-up-file-attached-exampleproblem
Sheet: Code Amperage

Primary Overcurrent Protection Sizing
Get transformer to VA |  |  | [NAME] (P / I * E) |  |  |  | 9 amps or more=125% |  | Secondary Overcurrent Protection
 |  |  |  |  |  |  | 9 amps or less=167%
 |  |  |  |  |  |  | (Table 450.3(b)
KVA | x 1000 | VA | VA | Divide/Multiply | Voltage*Sq. Root of 3 | Amperage | Code [NAME] | Code Required Amperage | Next Standard rating higher (Tabel 450.3(b) Note 1)
3 | 1000 | 3000 | 3000 | Divide | 831.384387633061 | 3.608439182435161 | 1.67 | 6.026093434666719 |  |  | I want the red cell to look at the orange cell, then compare it to the green cells on the "TABLES" tab and round up the the nearest value…..
6 | 1000 | 6000 | 6000 | Divide | 831.384387633061 | 7.216878364870323 | 1.67 | 12.05218686933344
9 | 1000 | 9000 | 9000 | Divide | 831.384387633061 | 10.82531754730548 | 1.25 | 13.53164693413186
15 | 1000 | 15000 | 15000 | Divide | 831.384387633061 | 18.04219591217581 | 1.25 | 22.55274489021976
30 | 1000 | 30000 | 30000 | Divide | 831.384387633061 | 36.08439182435161 | 1.25 | 45.10548978043951
45 | 1000 | 45000 | 45000 | Divide | 831.384387633061 | 54.12658773652742 | 1.25 | 67.65823467065927
75 | 1000 | 75000 | 75000 | Divide | 831.384387633061 | 90.21097956087904 | 1.25 | 112.7637244510988
112.5 | 1000 | 112500 | 112500 | Divide | 831.384387633061 | 135.3164693413186 | 1.25 | 169.1455866766482
150 | 1000 | 150000 | 150000 | Divide | 831.384387633061 | 180.4219591217581 | 1.25 | 225.5274489021976
225 | 1000 | 225000 | 225000 | Divide | 831.384387633061 | 270.6329386826371 | 1.25 | 338.2911733532964
300 | 1000 | 300000 | 300000 | Divide | 831.384387633061 | 360.8439182435162 | 1.25 | 451.0548978043952
500 | 1000 | 500000 | 500000 | Divide | 831.384387633061 | 601.4065304058603 | 1.25 | 751.7581630073254
Secondary Overcurrent Protection Sizing
Get transformer to VA |  |  | [NAME] (P / I * E) |  |  |  | Transformer is 9 amps or more (Table 450.3(b) |  | Secondary Overcurrent Protection
KVA | x 1000 | VA | VA | Divide/Multiply | Voltage*Sq. Root of 3 | Amperage | Code [NAME] | Code Required Amperage | Next Standard rating higher (Tabel 450.3(b) Note 1)
3 | 1000 | 3000 | 3000 | Divide | 360.2665679743264 | 8.327167344081142 | 1.67 | 13.9063694646155 | 20
6 | 1000 | 6000 | 6000 | Divide | 360.2665679743264 | 16.65433468816228 | 1.25 | 20.81791836020285 | 20
9 | 1000 | 9000 | 9000 | Divide | 360.2665679743264 | 24.98150203224342 | 1.25 | 31.22687754030428 | 30
15 | 1000 | 15000 | 15000 | Divide | 360.2665679743264 | 41.63583672040571 | 1.25 | 52.04479590050713 | 50
30 | 1000 | 30000 | 30000 | Divide | 360.2665679743264 | 83.27167344081141 | 1.25 | 104.0895918010143 | 100
45 | 1000 | 45000 | 45000 | Divide | 360.2665679743264 | 124.9075101612171 | 1.25 | 156.1343877015214 | 150
75 | 1000 | 75000 | 75000 | Divide | 360.2665679743264 | 208.1791836020285 | 1.25 | 260.2239795025357 | 125
112.5 | 1000 | 112500 | 112500 | Divide | 360.2665679743264 | 312.2687754030428 | 1.25 | 390.3359692538035 | 175
150 | 1000 | 150000 | 150000 | Divide | 360.2665679743264 | 416.3583672040571 | 1.25 | 520.4479590050713 | 250
225 | 1000 | 225000 | 225000 | Divide | 360.2665679743264 | 624.5375508060856 | 1.25 | 780.671938507607 | 350
300 | 1000 | 300000 | 300000 | Divide | 360.2665679743264 | 832.7167344081141 | 1.25 | 1040.895918010143 | 500
500 | 1000 | 500000 | 500000 | Divide | 360.2665679743264 | 1387.861224013523 | 1.25 | 1734.826530016904 | 800