Spreadsheet: 270354d1381444385-return-value-based-on-2-dependent-drop-down-lists-equipment-and-cost-estimate
Sheet: Piping and Fitting

Equipment and Cost Estimate - Piping and Fitting
Size | Material Description | Cost | Helper Column | Only [NAME] will be sufficient for this | <--- helper and uniique value columns can be hidden or you can use separate sheet | Drop down list - Size | Drop down list - Description | Cost | you can use sumproduct suggested by daffodill11
1/4'' | Tubing, SS, 304L, Bright Annealed | 1 |  |  |  | 1/4'' | Tubing, Copper, Type K
1/4'' | Tubing, SS, 316L, Electro Polished | 2 |  |  |  | 10'' | Tubing, SS, 304L, Bright Annealed
1/4'' | Tubing, Copper, Type K | 3
1/4'' | 90º Elbow, SS, 304L, Bright Annealed | 4
1/4'' | 90º Elbow, SS, 316L, Electro Polished | 5
1/4'' | 90º Elbow, Copper, Type K | 6
1/4'' | Tee, SS, 304L, Bright Annealed | 7
1/4'' | Tee, SS, 316L, Electro Polished | 8
1/4'' | Tee, Copper, Type K | 9
1/4'' x | [NAME], SS, 304L, Bright Annealed | 10
1/4'' x | [NAME], SS, 316L, Electro Polished | 11
1/4'' x | Reducer, Copper, Type K | 12
1/2'' | Tubing, SS, 304L, Bright Annealed | 13
1/2'' | Tubing, SS, 316L, Electro Polished | 14
1/2'' | Tubing, Copper, Type K | 15
1/2'' | Pipe, SS, Schedule 5 | 16
1/2'' | Pipe, SS, Schedule 10 | 17
1/2'' | Pipe, SS, Schedule 40 | 18
1/2'' | 90º Elbow, SS, 304L, Bright Annealed | 19
1/2'' | 90º Elbow, SS, 316L, Electro Polished | 20
1/2'' | 90º Elbow, Copper, Type K | 21
1/2'' | 90º Elbow, SS, Schedule 5 | 22
1/2'' | 90º Elbow, SS, Schedule 10 | 23
1/2'' | 90º Elbow, SS, Schedule 40 | 24
1/2'' | Tee, SS, 304L, Bright Annealed | 25
1/2'' | Tee, SS, 316L, Electro Polished | 26
1/2'' | Tee, Copper, Type K | 27
1/2'' | Tee, SS, Schedule 5 | 28
1/2'' | Tee, SS, Schedule 10 | 29
1/2'' | Tee, SS, Schedule 40 | 30
1/2'' x | [NAME], SS, 304L, Bright Annealed | 31
1/2'' x | [NAME], SS, 316L, Electro Polished | 32
1/2'' x | Reducer, Copper, Type K | 33
1/2'' x | [NAME], SS, Schedule 5 | 34
1/2'' x | [NAME], SS, Schedule 10 | 35
1/2'' x | [NAME], SS, Schedule 40 | 36
3/4'' | Tubing, SS, 304L, Bright Annealed | 37
3/4'' | Tubing, SS, 316L, Electro Polished | 38
3/4'' | Tubing, Copper, Type K | 39
3/4'' | Pipe, SS, Schedule 5 | 40
3/4'' | Pipe, SS, Schedule 10 | 41
3/4'' | Pipe, SS, Schedule 40 | 42
3/4'' | 90º Elbow, SS, 304L, Bright Annealed | 43
3/4'' | 90º Elbow, SS, 316L, Electro Polished | 44
3/4'' | 90º Elbow, Copper, Type K | 45
3/4'' | 90º Elbow, SS, Schedule 5 | 46
3/4'' | 90º Elbow, SS, Schedule 10 | 47
3/4'' | 90º Elbow, SS, Schedule 40 | 48
3/4'' | Tee, SS, 304L, Bright Annealed | 49
3/4'' | Tee, SS, 316L, Electro Polished | 50
3/4'' | Tee, Copper, Type K | 51
3/4'' | Tee, SS, Schedule 5 | 52
3/4'' | Tee, SS, Schedule 10 | 53
3/4'' | Tee, SS, Schedule 40 | 54
3/4'' x | [NAME], SS, 304L, Bright Annealed | 55
3/4'' x | [NAME], SS, 316L, Electro Polished | 56
3/4'' x | Reducer, Copper, Type K | 57
3/4'' x | [NAME], SS, Schedule 5 | 58
3/4'' x | [NAME], SS, Schedule 10 | 59
3/4'' x | [NAME], SS, Schedule 40 | 60
1'' | Tubing, SS, 304L, Bright Annealed | 61
1'' | Tubing, SS, 316L, Electro Polished | 62
1'' | Tubing, Copper, Type K | 63
1'' | Pipe, SS, Schedule 5 | 64
1'' | Pipe, SS, Schedule 10 | 65
1'' | Pipe, SS, Schedule 40 | 66
1'' | 90º Elbow, SS, 304L, Bright Annealed | 67
1'' | 90º Elbow, SS, 316L, Electro Polished | 68
1'' | 90º Elbow, Copper, Type K | 69
1'' | 90º Elbow, SS, Schedule 5 | 70
1'' | 90º Elbow, SS, Schedule 10 | 71
1'' | 90º Elbow, SS, Schedule 40 | 72
1'' | Tee, SS, 304L, Bright Annealed | 73
1'' | Tee, SS, 316L, Electro Polished | 74
1'' | Tee, Copper, Type K | 75
1'' | Tee, SS, Schedule 5 | 76
1'' | Tee, SS, Schedule 10 | 77
1'' | Tee, SS, Schedule 40 | 78
1'' x | [NAME], SS, 304L, Bright Annealed | 79
1'' x | [NAME], SS, 316L, Electro Polished | 80
1'' x | Reducer, Copper, Type K | 81
1'' x | [NAME], SS, Schedule 5 | 82
1'' x | [NAME], SS, Schedule 10 | 83
1'' x | [NAME], SS, Schedule 40 | 84
1-1/2'' | Tubing, SS, 304L, Bright Annealed | 85
1-1/2'' | Tubing, SS, 316L, Electro Polished | 86
1-1/2'' | Tubing, Copper, Type K | 87
1-1/2'' | Pipe, SS, Schedule 5 | 88
1-1/2'' | Pipe, SS, Schedule 10 | 89
1-1/2'' | Pipe, SS, Schedule 40 | 90
1-1/2'' | 90º Elbow, SS, 304L, Bright Annealed | 91
1-1/2'' | 90º Elbow, SS, 316L, Electro Polished | 92
1-1/2'' | 90º Elbow, Copper, Type K | 93
1-1/2'' | 90º Elbow, SS, Schedule 5 | 94
1-1/2'' | 90º Elbow, SS, Schedule 10 | 95
1-1/2'' | 90º Elbow, SS, Schedule 40 | 96
1-1/2'' | Tee, SS, 304L, Bright Annealed | 97
1-1/2'' | Tee, SS, 316L, Electro Polished | 98
1-1/2'' | Tee, Copper, Type K | 99
1-1/2'' | Tee, SS, Schedule 5 | 100
1-1/2'' | Tee, SS, Schedule 10 | 101
1-1/2'' | Tee, SS, Schedule 40 | 102
1-1/2'' x | [NAME], SS, 304L, Bright Annealed | 103
1-1/2'' x | [NAME], SS, 316L, Electro Polished | 104
1-1/2'' x | Reducer, Copper, Type K | 105
1-1/2'' x | [NAME], SS, Schedule 5 | 106
1-1/2'' x | [NAME], SS, Schedule 10 | 107
1-1/2'' x | [NAME], SS, Schedule 40 | 108
2'' | Tubing, SS, 304L, Bright Annealed | 109
2'' | Tubing, SS, 316L, Electro Polished | 110
2'' | Tubing, Copper, Type K | 111
2'' | Pipe, SS, Schedule 5 | 112
2'' | Pipe, SS, Schedule 10 | 113
2'' | Pipe, SS, Schedule 40 | 114
2'' | 90º Elbow, SS, 304L, Bright Annealed | 115
2'' | 90º Elbow, SS, 316L, Electro Polished | 116
2'' | 90º Elbow, Copper, Type K | 117
2'' | 90º Elbow, SS, Schedule 5 | 118
2'' | 90º Elbow, SS, Schedule 10 | 119
2'' | 90º Elbow, SS, Schedule 40 | 120
2'' | Tee, SS, 304L, Bright Annealed | 121
2'' | Tee, SS, 316L, Electro Polished | 122
2'' | Tee, Copper, Type K | 123
2'' | Tee, SS, Schedule 5 | 124
2'' | Tee, SS, Schedule 10 | 125
2'' | Tee, SS, Schedule 40 | 126
2'' x | [NAME], SS, 304L, Bright Annealed | 127
2'' x | [NAME], SS, 316L, Electro Polished | 128
2'' x | Reducer, Copper, Type K | 129
2'' x | [NAME], SS, Schedule 5 | 130
2'' x | [NAME], SS, Schedule 10 | 131
2'' x | [NAME], SS, Schedule 40 | 132
3'' | Tubing, SS, 304L, Bright Annealed | 133
3'' | Tubing, SS, 316L, Electro Polished | 134
3'' | Tubing, Copper, Type K | 135
3'' | Pipe, SS, Schedule 5 | 136
3'' | Pipe, SS, Schedule 10 | 137
3'' | Pipe, SS, Schedule 40 | 138
3'' | 90º Elbow, SS, 304L, Bright Annealed | 139
3'' | 90º Elbow, SS, 316L, Electro Polished | 140
3'' | 90º Elbow, Copper, Type K | 141
3'' | 90º Elbow, SS, Schedule 5 | 142
3'' | 90º Elbow, SS, Schedule 10 | 143
3'' | 90º Elbow, SS, Schedule 40 | 144
3'' | Tee, SS, 304L, Bright Annealed | 145
3'' | Tee, SS, 316L, Electro Polished | 146
3'' | Tee, Copper, Type K | 147
3'' | Tee, SS, Schedule 5 | 148
3'' | Tee, SS, Schedule 10 | 149
3'' | Tee, SS, Schedule 40 | 150
3'' x | [NAME], SS, 304L, Bright Annealed | 151
3'' x | [NAME], SS, 316L, Electro Polished | 152
3'' x | Reducer, Copper, Type K | 153
3'' x | [NAME], SS, Schedule 5 | 154
3'' x | [NAME], SS, Schedule 10 | 155
3'' x | [NAME], SS, Schedule 40 | 156
4'' | Tubing, SS, 304L, Bright Annealed | 157
4'' | Tubing, SS, 316L, Electro Polished | 158
4'' | Tubing, Copper, Type K | 159
4'' | Pipe, SS, Schedule 5 | 160
4'' | Pipe, SS, Schedule 10 | 161
4'' | Pipe, SS, Schedule 40 | 162
4'' | 90º Elbow, SS, 304L, Bright Annealed | 163
4'' | 90º Elbow, SS, 316L, Electro Polished | 164
4'' | 90º Elbow, Copper, Type K | 165
4'' | 90º Elbow, SS, Schedule 5 | 166
4'' | 90º Elbow, SS, Schedule 10 | 167
4'' | 90º Elbow, SS, Schedule 40 | 168
4'' | Tee, SS, 304L, Bright Annealed | 169
4'' | Tee, SS, 316L, Electro Polished | 170
4'' | Tee, Copper, Type K | 171
4'' | Tee, SS, Schedule 5 | 172
4'' | Tee, SS, Schedule 10 | 173
4'' | Tee, SS, Schedule 40 | 174
4'' x | [NAME], SS, 304L, Bright Annealed | 175
4'' x | [NAME], SS, 316L, Electro Polished | 176
4'' x | Reducer, Copper, Type K | 177
4'' x | [NAME], SS, Schedule 5 | 178
4'' x | [NAME], SS, Schedule 10 | 179
4'' x | [NAME], SS, Schedule 40 | 180
6'' | Tubing, SS, 304L, Bright Annealed | 181
6'' | Tubing, SS, 316L, Electro Polished | 182
6'' | Tubing, Copper, Type K | 183
6'' | Pipe, SS, Schedule 5 | 184
6'' | Pipe, SS, Schedule 10 | 185
6'' | Pipe, SS, Schedule 40 | 186
6'' | 90º Elbow, SS, 304L, Bright Annealed | 187
6'' | 90º Elbow, SS, 316L, Electro Polished | 188
6'' | 90º Elbow, Copper, Type K | 189
6'' | 90º Elbow, SS, Schedule 5 | 190
6'' | 90º Elbow, SS, Schedule 10 | 191
6'' | 90º Elbow, SS, Schedule 40 | 192
6'' | Tee, SS, 304L, Bright Annealed | 193
6'' | Tee, SS, 316L, Electro Polished | 194
6'' | Tee, Copper, Type K | 195
6'' | Tee, SS, Schedule 5 | 196
6'' | Tee, SS, Schedule 10 | 197
6'' | Tee, SS, Schedule 40 | 198
6'' x | [NAME], SS, 304L, Bright Annealed | 199
6'' x | [NAME], SS, 316L, Electro Polished | 200
6'' x | Reducer, Copper, Type K | 201
6'' x | [NAME], SS, Schedule 5 | 202
6'' x | [NAME], SS, Schedule 10 | 203
6'' x | [NAME], SS, Schedule 40 | 204
8'' | Tubing, SS, 304L, Bright Annealed | 205
8'' | Tubing, SS, 316L, Electro Polished | 206
8'' | Tubing, Copper, Type K | 207
8'' | Pipe, SS, Schedule 5 | 208
8'' | Pipe, SS, Schedule 10 | 209
8'' | Pipe, SS, Schedule 40 | 210
8'' | 90º Elbow, SS, 304L, Bright Annealed | 211
8'' | 90º Elbow, SS, 316L, Electro Polished | 212
8'' | 90º Elbow, Copper, Type K | 213
8'' | 90º Elbow, SS, Schedule 5 | 214
8'' | 90º Elbow, SS, Schedule 10 | 215
8'' | 90º Elbow, SS, Schedule 40 | 216
8'' | Tee, SS, 304L, Bright Annealed | 217
8'' | Tee, SS, 316L, Electro Polished | 218
8'' | Tee, Copper, Type K | 219
8'' | Tee, SS, Schedule 5 | 220
8'' | Tee, SS, Schedule 10 | 221
8'' | Tee, SS, Schedule 40 | 222
8'' x | [NAME], SS, 304L, Bright Annealed | 223
8'' x | [NAME], SS, 316L, Electro Polished | 224
8'' x | Reducer, Copper, Type K | 225
8'' x | [NAME], SS, Schedule 5 | 226
8'' x | [NAME], SS, Schedule 10 | 227
8'' x | [NAME], SS, Schedule 40 | 228
10'' | Tubing, SS, 304L, Bright Annealed | 229
10'' | Tubing, SS, 316L, Electro Polished | 230
10'' | Tubing, Copper, Type K | 231
10'' | Pipe, SS, Schedule 5 | 232
10'' | Pipe, SS, Schedule 10 | 233
10'' | Pipe, SS, Schedule 40 | 234
10'' | 90º Elbow, SS, 304L, Bright Annealed | 235
10'' | 90º Elbow, SS, 316L, Electro Polished | 236
10'' | 90º Elbow, Copper, Type K | 237
10'' | 90º Elbow, SS, Schedule 5 | 238
10'' | 90º Elbow, SS, Schedule 10 | 239
10'' | 90º Elbow, SS, Schedule 40 | 240
10'' | Tee, SS, 304L, Bright Annealed | 241
10'' | Tee, SS, 316L, Electro Polished | 242
10'' | Tee, Copper, Type K | 243
10'' | Tee, SS, Schedule 5 | 244
10'' | Tee, SS, Schedule 10 | 245
10'' | Tee, SS, Schedule 40 | 246
10'' x | [NAME], SS, 304L, Bright Annealed | 247
10'' x | [NAME], SS, 316L, Electro Polished | 248
10'' x | Reducer, Copper, Type K | 249
10'' x | [NAME], SS, Schedule 5 | 250
10'' x | [NAME], SS, Schedule 10 | 251
10'' x | [NAME], SS, Schedule 40 | 252
12'' | Tubing, SS, 304L, Bright Annealed | 253
12'' | Tubing, SS, 316L, Electro Polished | 254
12'' | Tubing, Copper, Type K | 255
12'' | Pipe, SS, Schedule 5 | 256
12'' | Pipe, SS, Schedule 10 | 257
12'' | Pipe, SS, Schedule 40 | 258
12'' | 90º Elbow, SS, 304L, Bright Annealed | 259
12'' | 90º Elbow, SS, 316L, Electro Polished | 260
12'' | 90º Elbow, Copper, Type K | 261
12'' | 90º Elbow, SS, Schedule 5 | 262
12'' | 90º Elbow, SS, Schedule 10 | 263
12'' | 90º Elbow, SS, Schedule 40 | 264
12'' | Tee, SS, 304L, Bright Annealed | 265
12'' | Tee, SS, 316L, Electro Polished | 266
12'' | Tee, Copper, Type K | 267
12'' | Tee, SS, Schedule 5 | 268
12'' | Tee, SS, Schedule 10 | 269
12'' | Tee, SS, Schedule 40 | 270
12'' x | [NAME], SS, 304L, Bright Annealed | 271
12'' x | [NAME], SS, 316L, Electro Polished | 272
12'' x | Reducer, Copper, Type K | 273
12'' x | [NAME], SS, Schedule 5 | 274
12'' x | [NAME], SS, Schedule 10 | 275
12'' x | [NAME], SS, Schedule 40 | 276