Spreadsheet: 125414d1319023705-lookup-with-multiple-criteria-on-multiple-tabs-indexmatch
Sheet: Price

 | Commodity | 1 | 50 | 100
N | #1 Copper | 2.6 | 2.62 | 2.65
N | #1 Insul. Copper wire | 1.5 | 1.52 | 1.55
F | #1 Steel | 0.13 | 0.13
N | #2 Copper | 2.4 | 2.42 | 2.45
N | #2 Insul. Copper wire | 1 | 1.02 | 1.05
F | #2 Steel |  | 0.13
N | 3003 Alum
F | 5' Plate/Structural | 0.135 | 0.135
N | 5052 Alum
N | 6061 Alum | 0.65 | 0.67 | 0.69
N | 6061 Alum Turnings
N | 70/30 ADM
N | 70/30 Clips
N | ACSR
N | [NAME]
N | AL-CU Radiator | 1.4 | 1.42 | 1.44
N | Alternator | 0.38 | 0.39 | 0.4
N | Alum Breakage | 0.14 | 0.15 | 0.16
N | [NAME]
N | Alum Bumpers
N | Alum Busbar
N | Alum Cans | 0.6 | 0.61 | 0.62
N | [NAME]
N | Alum Foil | 0.25 | 0.26 | 0.27
N | Alum Fuel Tanks
N | [NAME] | 0.65 | 0.66 | 0.67
N | Alum Radiators | 0.54 | 0.56 | 0.58
N | Alum Rims | 0.72 | 0.73 | 0.74
N | Alum Siding | 0.59 | 0.6 | 0.61
N | Alum Signs
N | Alum Transformer (Case) | 0.11 | 0.12 | 0.13
N | Alum Transformer (No Case) | 0.14 | 0.15 | 0.16
N | Alum Turnings | 0.3 | 0.31 | 0.32
F | Auto Cast | 0.13 | 0.13
N | Auto Radiator | 1.65 | 1.67 | 1.69
N | Ballast | 0.1 | 0.11 | 0.12
N | Bare Bright Copper | 2.7 | 2.72 | 2.75
N | [NAME] | 0.15 | 0.16 | 0.17
N | Batteries
N | Black CATV | 0.12 | 0.13 | 0.14
N | [NAME] | 1.15 | 1.16 | 1.17
N | [NAME] | 1.1 | 1.12 | 1.15
N | [NAME] | 1.25 | 1.26 | 1.27
F | Busheling | 0.135 | 0.135
N | Carbide | 4 | 4.5 | 5
N | Cardboard
N | Cars
N | Cast Aluminum | 0.52 | 0.53 | 0.54
F | Cast Iron |  | 0.12
N | Chargers
N | [NAME]
N | Christmas Lights | 0.25 | 0.27 | 0.3
N | Compressors | 0.14 | 0.15 | 0.16
N | Concrete Forms | 0.54 | 0.55 | 0.56
N | Converters
N | Copper Bearing | 0.05 | 0.06 | 0.07
N | Copper Busbar
N | Copper Helix
N | Copper Transformer (Case) | 0.15 | 0.16 | 0.17
N | Copper Transformer (No Case) | 0.2 | 0.21 | 0.22
N | Copper Turnings | 1.45 | 1.47 | 1.5
N | Die Cast | 0.3 | 0.32 | 0.35
N | E Scrap
N | EC Wire | 0.72 | 0.73 | 0.74
N | EDM Wire | 1.45 | 1.47 | 1.5
N | Electric Motors | 0.23 | 0.24 | 0.25
N | Extrusion | 0.67 | 0.68 | 0.69
N | Freight
N | [NAME] | 0.12 | 0.13 | 0.14
N | [NAME]
F | HB Cast Iron |  | 0.08
N | [NAME] | 1.15 | 1.17 | 1.19
N | Inconel | 0.8 | 0.85 | 0.9
N | [NAME]/ACSR | 0.3 | 0.31 | 0.32
N | [NAME]
N | Jelly Wire | 1 | 1.01 | 1.02
N | Lead | 0.4 | 0.42 | 0.45
N | Lead Coated Cu | 0.3 | 0.31 | 0.32
N | Low Grade Wire | 0.55 | 0.57 | 0.6
N | Magnesium | 0.4 | 0.42 | 0.45
N | [NAME]
N | [NAME]
N | [NAME] | 1.2 | 1.22 | 1.25
F | Mixed Iron |  | 0.12
F | [NAME]
N | [NAME] | 0.55 | 0.56 | 0.57
N | MLC with Poly | 0.5 | 0.51 | 0.52
N | Moly
N | New Cast Aluminum | 0.54 | 0.55 | 0.56
N | New Extrusion | 0.72 | 0.73 | 0.74
N | New Pro Painted Extrusion
N | Newspaper
N | Nickel | 3 | 3.2 | 3.5
N | Painted MLC | 0.5 | 0.51 | 0.52
N | Painted Siding | 0.59 | 0.6 | 0.61
N | Phos Bronze | 2.3 | 2.32 | 2.35
N | Plastics
N | Radiator Ends | 0.2 | 0.22 | 0.25
F | Rail |  | 0.13 | 0.135
N | Range Lead | 0.25 | 0.26 | 0.27
F | Rebar |  | 0.0675
N | Red Brass | 1.9 | 1.92 | 1.95
N | Sheet Aluminum | 0.52 | 0.53 | 0.54
N | Sheet Copper | 2.25 | 2.27 | 2.3
F | Sheet Iron | 0.12 | 0.12
N | Soft Lead | 0.25 | 0.26 | 0.27
N | Stainless (304) | 0.52 | 0.54 | 0.56
N | Stainless (316) | 0.77 | 0.59 | 0.81
N | Stainless (400) | 0.14 | 0.16 | 0.18
N | Stainless Turnings | 0.3 | 0.31 | 0.32
N | Starter | 0.28 | 0.29 | 0.3
N | Stators | 0.23 | 0.24 | 0.25
N | Steel Cased Batteries | 0.18 | 0.19 | 0.2
F | Steel Turnings | 0.0725 | 0.08 | 0.09
F | Tin
N | Titanium | 0.4 | 0.42 | 0.45
F | Tool Steel
F | Torching | 0.1025 | 0.1025
N | Transmissions | 0.14 | 0.15 | 0.16
N | Unc. [NAME] | 0.35 | 0.36 | 0.37
N | Unc. [NAME] | 0.66 | 0.67 | 0.68
N | Unc. [NAME] | 0.12 | 0.13 | 0.14
N | Unc. AL/CU Radiators | 1.15 | 1.17 | 1.18
N | Unc. [NAME]
N | Unc. Auto Radiators | 1.05 | 1.07 | 1.09
N | Unc. Brass | 0.45 | 0.47 | 0.5
N | Unc. Copper
N | Unc. Copper Turnings | 0.4 | 0.41 | 0.42
N | Unc. Extrusion | 0.54 | 0.55 | 0.56
N | Unc. Lead | 0.2 | 0.21 | 0.22
F | Unc. Motor Blocks | 0.125 | 0.125
F | Unc. Sheet | 0.1075 | 0.1075
N | Unc. Stainless | 0.15 | 0.2 | 0.25
N | Unc. Stainless Turnings | 0.15 | 0.16 | 0.17
F | Unprepared Plate/Structural | 0.125 | 0.125
N | Wheel Weights | 0.2 | 0.22 | 0.25
N | Wire Harness | 0.25 | 0.27 | 0.3
N | [NAME] | 1.8 | 1.82 | 1.85
N | Yellow Brass Turnings | 1.15 | 1.17 | 1.2
N | Zinc | 0.25 | 0.26 | 0.27