Spreadsheet: 41983d1240515231-how-do-i-use-a-live-formula-result-in-another-formula-example
Sheet: Sheet1

 |  | Coating | Description | Diameter | Length |  | Part # A | Part # B
Part Number | FS | S | 5 | 9 | 8 |  | 598 | #N/A
Part Description |  |  | [NAME] | 3/8" | 5/16"
1 |  |  | 2 | 3 | 3 |  | Part # A | Part # B
Plain |  | 1 | Steel Ball | 1 | 1/16" or #4 |  | 7711 | 13001
P= Plated |  | 2 | Carriage Bolt | 2 | 3/32" or #6 |  | 7723 | 110120306
[NAME] |  | 3 | Plow Bolt | 3 | 7/64 or #8 |  | 7820 | 13055
 |  | 4 | [NAME] | 4 | 1/8 or #10 |  | 7822 | 13057
 |  | 6 | HCS (UNC) Gr 2 | 5 | 5/32" or #12 |  | 7830 | 110120329
 |  | 7 | HCS (UNC) Gr 5 | 6 | 3/16" or #14 |  | 7913 | 110161614
 |  | 8 | HCS (UNC) Gr 8 | 7 | 1/4" |  | 7934 | 110120350
 |  | 9 | HCS (UNF) Gr 2 | 8 | 5/16" |  | 7964 | 13124
 |  | 10 | HCS (UNF) Gr 5 | 9 | 3/8" |  | 71164 | 13224
 |  | 11 | HCS (UNF) Gr 8 | 10 | 7/16" |  | 71330 | 13311
 |  | 12 | [NAME] (UNF) | 11 | 1/2" |  | 71380 | 13327
 |  | 13 | [NAME] (UNC) | 12 | 9/16" |  | 8942 | 0115116
 |  | 14 | Flat SHCS (UNC) | 13 | 5/8" |  | 8970 | 0115125
 |  | 15 | Flat SHCS (UNF) | 14 | 11/16" |  | 81024 | 0115159
 |  | 16 | Aluminum HCS (UNC) | 15 | 3/4" |  | 101122 | 17207
 |  | 17 | Thumbscrew | 16 | 13/16" |  | 11844 | 18067
 |  | 19 | Grease Fitting | 17 | 7/8" |  | 11922 | 0118836
 |  | 20 | Nail | 18 | 15/16" |  | 21500 | 36267
 |  | 21 | Nut (UNF) Special | 20 | 1" |  | 2120 | 37880
 |  | 22 | Nut (UNC) Special | 21 | 1-1/8" |  | 2220 | 36419
 |  | 23 | Lock Nut (UNC) Gr 5 | 22 | 1-1/4" |  | 239 | 70862
 |  | 24 | Lock Nut (UNF) Gr 5 | 23 | 1-3/8" |  | 2310 | 37268
 |  | 25 | Hex Nut (UNF) Plated | 24 | 1-1/2" |  | 244 | 37015
 |  | 26 | Hex Nut (UCF) Plated | 25 | 1-5/8" |  | 247 | 37300
 |  | 27 | Hex Nut (UNF) Plain | 26 | 1-3/4" |  | 2710 | 36358
 |  | 28 | Hex Nut (UCF) Plain | 27 | 1-7/8" |  | 289 | 36306
 |  | 29 | [NAME] (UNC) | 30 | 2" |  | 2915 | 36216
 |  | 30 | [NAME] (UNF) | 32 | 2-1/4" |  | 308 | 0169546
 |  | 31 | Slotted or Castle Nut (UNC) | 34 | 2-1/2" |  | 3010 | 36258
 |  | 32 | Lock Nut (UNC) Gr 8 | 36 | 2-3/4" |  | 313175 | 37328
 |  | 33 | Slotted Nut (UNF) | 40 | 3" |  | 36915 | 64303
 |  | 34 | Steel Cotter Pin | 42 | 3-1/4" |  | 36114 | 64359
 |  | 35 | Lock Nut (UNF) Gr 8 | 44 | 3-1/2" |  | 41923 | 23308
 |  | 36 | Steel Taper Pin | 46 | 3-3/4" |  | 42211 | 28803
 |  | 37 | Rivet | 50 | 4" |  | 4239 | 28869
 |  | 38 | Thread Protractor | 52 | 4-1/4" |  | 42324 | 28912
 |  | 39 | Drive Screw | 54 | 4-1/2" |  | 42424 | 27582
 |  | 40 | Round HD [NAME]. [NAME] (UNF) | 56 | 4-3/4" |  | 42460 | 27601
 |  | 41 | Flat HD [NAME]. [NAME] | 60 | 5" |  | 44915 | 25541
 |  | 42 | Round HD [NAME]. [NAME] (UNC) | 62 | 5-1/4" |  | 4577 | 25396
 |  | 43 | [NAME]. [NAME] | 64 | 5-1/2" |  | 4579 | 25398
 |  | 44 | Socket Set Screw (UNC) | 66 | 5-3/4" |  | 518 | 33858
 |  | 45 | Socket Set Screw (UNF) | 70 | 6" |  | 5122 | 33824
 |  | 46 | Square HD Set Screw (UNC) | 72 | 6-1/4" |  | 5124 | 33870
 |  | 48 | Square HD Set [NAME] (UNF) | 74 | 6-1/2" |  | 527 | 33813
 |  | 49 | Self Tapping Screw | 76 | 6-3/4" |  | 5215 | 33820
 |  | 50 | TEK Screw | 80 | 7" |  | 5223 | 33102
 |  | 51 | [NAME] plain | 82 | 7-1/4" |  | 904 | 24132
 |  | 52 | SAE Washer plain | 84 | 7-1/2" |  | 2822 | 21812
 |  | 53 | Bevel Washer | 86 | 7-3/4" |  | 2899 | 21286
 |  | 54 | Lock Washer plain | 90 | 8" |  | 2920 | 21817
 |  | 55 | Lock Washer plated | 91 | 8-1/4" |  | 2922 | 21257
 |  | 57 | [NAME] | 92 | 8-1/2" |  | 2924 | 21819
 |  | 59 | Malleable Reducing Bushing | 94 | 8-3/4" |  | 21122 | 21823
 |  |  |  | 96 | 9" |  | 7713 | 13002
 |  |  |  | 97 | 9-1/4" |  | 7715 | 13003
 |  |  |  | 98 | 9-1/2" |  | 7717 | 13004
 |  |  |  | 99 | 16" |  | 7720 | 13005
 |  |  |  |  |  |  | 7722 | 13007
 |  |  |  |  |  |  | 7724 | 13009
 |  |  |  |  |  |  | 7726 | 13010
 |  |  |  |  |  |  | 7730 | 13011
 |  |  |  |  |  |  | 7732 | 13012
 |  |  |  |  |  |  | 7815 | 13053
 |  |  |  |  |  |  | 7824 | 13059
 |  |  |  |  |  |  | 7826 | 13060
 |  |  |  |  |  |  | 7834 | 13063
 |  |  |  |  |  |  | 7840 | 13065
 |  |  |  |  |  |  | 7915 | 13103
 |  |  |  |  |  |  | 7920 | 13105
 |  |  |  |  |  |  | 7922 | 13107
 |  |  |  |  |  |  | 7924 | 13109
 |  |  |  |  |  |  | 7926 | 13110
 |  |  |  |  |  |  | 7930 | 13111
 |  |  |  |  |  |  | 7934 | 13113
 |  |  |  |  |  |  | 7936 | 13114
 |  |  |  |  |  |  | 7940 | 13115
 |  |  |  |  |  |  | 7942 | 13116
 |  |  |  |  |  |  | 7950 | 13119
 |  |  |  |  |  |  | 7952 | 13120
 |  |  |  |  |  |  | 7954 | 13121
 |  |  |  |  |  |  | 7956 | 13122
 |  |  |  |  |  |  | 7974 | 13126
 |  |  |  |  |  |  | 71040 | 13165
 |  |  |  |  |  |  | 71120 | 13205
 |  |  |  |  |  |  | 71122 | 13207
 |  |  |  |  |  |  | 71124 | 13209
 |  |  |  |  |  |  | 71126 | 13210
 |  |  |  |  |  |  | 71130 | 13211
 |  |  |  |  |  |  | 71134 | 13213
 |  |  |  |  |  |  | 71140 | 13215
 |  |  |  |  |  |  | 71144 | 13217
 |  |  |  |  |  |  | 71146 | 13218
 |  |  |  |  |  |  | 71150 | 13219
 |  |  |  |  |  |  | 71154 | 13221
 |  |  |  |  |  |  | 71160 | 13223
 |  |  |  |  |  |  | 71190 | 13229
 |  |  |  |  |  |  | 71193 | 13232
 |  |  |  |  |  |  | 71322 | 13307
 |  |  |  |  |  |  | 71324 | 13309
 |  |  |  |  |  |  | 71326 | 13310
 |  |  |  |  |  |  | 71332 | 13312
 |  |  |  |  |  |  | 71334 | 13313
 |  |  |  |  |  |  | 71336 | 13314
 |  |  |  |  |  |  | 71340 | 13315
 |  |  |  |  |  |  | 71346 | 13318
 |  |  |  |  |  |  | 71360 | 13323
 |  |  |  |  |  |  | 71370 | 13325
 |  |  |  |  |  |  | 71524 | 13359
 |  |  |  |  |  |  | 71530 | 13361
 |  |  |  |  |  |  | 71534 | 13363
 |  |  |  |  |  |  | 71536 | 13364
 |  |  |  |  |  |  | 71550 | 13369
 |  |  |  |  |  |  | 71560 | 13373
 |  |  |  |  |  |  | 71580 | 13377
 |  |  |  |  |  |  | 7270 | 13475
 |  |  |  |  |  |  | 8711 | 18001
 |  |  |  |  |  |  | 8936 | 12114
 |  |  |  |  |  |  | 8960 | 15123
 |  |  |  |  |  |  | 8970 | 15125
 |  |  |  |  |  |  | 8134 | 15163
 |  |  |  |  |  |  | 81122 | 15207
 |  |  |  |  |  |  | 81130 | 15211
 |  |  |  |  |  |  | 81132 | 15212
 |  |  |  |  |  |  | 81136 | 15214
 |  |  |  |  |  |  | 81146 | 15218
 |  |  |  |  |  |  | 81180 | 15227
 |  |  |  |  |  |  | 81326 | 15310
 |  |  |  |  |  |  | 81330 | 15311
 |  |  |  |  |  |  | 81332 | 15312
 |  |  |  |  |  |  | 81334 | 15313
 |  |  |  |  |  |  | 81336 | 15314
 |  |  |  |  |  |  | 81354 | 15321
 |  |  |  |  |  |  | 81534 | 15363
 |  |  |  |  |  |  | 81546 | 15368
 |  |  |  |  |  |  | 81560 | 15373
 |  |  |  |  |  |  | 82040 | 15465
 |  |  |  |  |  |  | 82070 | 15475
 |  |  |  |  |  |  | 10713 | 17002
 |  |  |  |  |  |  | 10813 | 17052
 |  |  |  |  |  |  | 10822 | 17057
 |  |  |  |  |  |  | 10826 | 17060
 |  |  |  |  |  |  | 10836 | 17064
 |  |  |  |  |  |  | 10913 | 17102
 |  |  |  |  |  |  | 10915 | 17103
 |  |  |  |  |  |  | 10922 | 17107
 |  |  |  |  |  |  | 10932 | 17112
 |  |  |  |  |  |  | 10934 | 17113
 |  |  |  |  |  |  | 10936 | 17114
 |  |  |  |  |  |  | 101120 | 17205
 |  |  |  |  |  |  | 101130 | 17211
 |  |  |  |  |  |  | 101134 | 17213
 |  |  |  |  |  |  | 101136 | 17214
 |  |  |  |  |  |  | 101142 | 17216
 |  |  |  |  |  |  | 101146 | 17218
 |  |  |  |  |  |  | 101156 | 17222
 |  |  |  |  |  |  | 101160 | 17223
 |  |  |  |  |  |  | 101330 | 17311
 |  |  |  |  |  |  | 101332 | 17312
 |  |  |  |  |  |  | 101334 | 17313
 |  |  |  |  |  |  | 101336 | 17314
 |  |  |  |  |  |  | 101340 | 17315
 |  |  |  |  |  |  | 107 | 1133004
 |  |  |  |  |  |  | 11924 | 0118838
 |  |  |  |  |  |  | 111136 | 18917
 |  |  |  |  |  |  | 111342 | 18966
 |  |  |  |  |  |  | 112060 | 18473
 |  |  |  |  |  |  | 131024 | 23359
 |  |  |  |  |  |  | 131120 | 23405
 |  |  |  |  |  |  | 131332 | 23512
 |  |  |  |  |  |  | 19400 | 60102
 |  |  |  |  |  |  | 19445 | 60103
 |  |  |  |  |  |  | 19490 | 60104
 |  |  |  |  |  |  | 197 | 60105
 |  |  |  |  |  |  | 19745 | 60106
 |  |  |  |  |  |  | 19790 | 60107
 |  |  |  |  |  |  | 2111 | 0169629
 |  |  |  |  |  |  | 232 | 37010
 |  |  |  |  |  |  | 237 | 37260
 |  |  |  |  |  |  | 237 | 37260
 |  |  |  |  |  |  | 238 | 37262
 |  |  |  |  |  |  | 239 | 37264
 |  |  |  |  |  |  | 2310 | 37266
 |  |  |  |  |  |  | 2311 | 37268
 |  |  |  |  |  |  | 2313 | 37272
 |  |  |  |  |  |  | 2315 | 37274
 |  |  |  |  |  |  | 2320 | 37278
 |  |  |  |  |  |  | 248 | 37302
 |  |  |  |  |  |  | 249 | 37304
 |  |  |  |  |  |  | 2411 | 37308
 |  |  |  |  |  |  | 2413 | 37312
 |  |  |  |  |  |  | 2415 | 37314
 |  |  |  |  |  |  | 2517 | 36468
 |  |  |  |  |  |  | 2524 | 36478
 |  |  |  |  |  |  | 274 | 36030
 |  |  |  |  |  |  | 278 | 36354
 |  |  |  |  |  |  | 279 | 36456
 |  |  |  |  |  |  | 2711 | 36360
 |  |  |  |  |  |  | 2722 | 36374
 |  |  |  |  |  |  | 282 | 36020
 |  |  |  |  |  |  | 283 | 36024
 |  |  |  |  |  |  | 287 | 36302
 |  |  |  |  |  |  | 2811 | 36310
 |  |  |  |  |  |  | 2815 | 36416
 |  |  |  |  |  |  | 299 | 0169533
 |  |  |  |  |  |  | 311 | 0169549
 |  |  |  |  |  |  | 3120 | 0169835
 |  |  |  |  |  |  | 3211 | 12374-00933
 |  |  |  |  |  |  | 3213 | 12374-00901
 |  |  |  |  |  |  | 3215 | 12374-00932
 |  |  |  |  |  |  | 3320 | 36869
 |  |  |  |  |  |  | 34212 | 65034
 |  |  |  |  |  |  | 34412 | 65074
 |  |  |  |  |  |  | 34420 | 65076
 |  |  |  |  |  |  | 34630 | 65127
 |  |  |  |  |  |  | 34724 | 65145
 |  |  |  |  |  |  | 34730 | 65147
 |  |  |  |  |  |  | 34732 | 65148
 |  |  |  |  |  |  | 34740 | 65151
 |  |  |  |  |  |  | 3520 | 37318
 |  |  |  |  |  |  | 4049 | 27542
 |  |  |  |  |  |  | 41916 | 94090
 |  |  |  |  |  |  | 411120 | 94109
 |  |  |  |  |  |  | 42220 | 28827
 |  |  |  |  |  |  | 42224 | 28837
 |  |  |  |  |  |  | 42320 | 28902
 |  |  |  |  |  |  | 42411 | 27548
 |  |  |  |  |  |  | 42415 | 27560
 |  |  |  |  |  |  | 42420 | 27572
 |  |  |  |  |  |  | 42428 | 27590
 |  |  |  |  |  |  | 42440 | 27598
 |  |  |  |  |  |  | 44811 | 25439
 |  |  |  |  |  |  | 49311 | 31831
 |  |  |  |  |  |  | 517 | 33857
 |  |  |  |  |  |  | 518 | 33006
 |  |  |  |  |  |  | 519 | 33859
 |  |  |  |  |  |  | 5110 | 33860
 |  |  |  |  |  |  | 5111 | 33861
 |  |  |  |  |  |  | 5113 | 33863
 |  |  |  |  |  |  | 5115 | 33864
 |  |  |  |  |  |  | 5120 | 33866
 |  |  |  |  |  |  | 524 | 33078
 |  |  |  |  |  |  | 527 | 33813
 |  |  |  |  |  |  | 528 | 33814
 |  |  |  |  |  |  | 529 | 33815
 |  |  |  |  |  |  | 5210 | 33816
 |  |  |  |  |  |  | 5211 | 33817
 |  |  |  |  |  |  | 5220 | 33822
 |  |  |  |  |  |  | 5223 | 33825
 |  |  |  |  |  |  | 5224 | 33826
 |  |  |  |  |  |  | 53824 | 33215
 |  |  |  |  |  |  | 549 | 33622
 |  |  |  |  |  |  | 5411 | 33626
 |  |  |  |  |  |  | 5413 | 33630
 |  |  |  |  |  |  | 554 | 33614
 |  |  |  |  |  |  | 557 | 33618
 |  |  |  |  |  |  | 558 | 33620
 |  |  |  |  |  |  | 559 | 33622
 |  |  |  |  |  |  | 5510 | 33624
 |  |  |  |  |  |  | 7715 | 70003
 |  |  |  |  |  |  | 7720 | 70005
 |  |  |  |  |  |  | 7820 | 70055
 |  |  |  |  |  |  | 7915 | 70103
 |  |  |  |  |  |  | 7923 | 0172270
 |  |  |  |  |  |  | 237 | 70796
 |  |  |  |  |  |  | 517 | 71014
 |  |  |  |  |  |  | 518 | 71015
 |  |  |  |  |  |  | 527 | 71013
 |  |  |  |  |  |  | 557 | 71063