Spreadsheet: 100923d1299137644-vlookup-error-in-some-cells-but-not-others-costings-template-automated-rev10-big-resource
Sheet: Tubulars

Alloy | Tube Density constant | Trademark Name | Density(g/cm3)
Alumnium 1100 | 0.008513716090985 |  | 2.71
Aluminium 2024 | 0.00873362757673 |  | 2.78
Aluminium 3003 | 0.008576547944055 |  | 2.73
Aluminium 5052 | 0.008419468311380001 |  | 2.68
Aluminium 6061 | 0.00848230016445 |  | 2.7
Aluminium 7075 | 0.008827875356335 |  | 2.81
Aluminium 5052 | 0.008419468311380001 |  | 2.68
304/304L | 0.02494424566879 |  | 7.94
316/316L | 0.02506990937493001 |  | 7.98
309/310 | 0.02506990937493001 |  | 7.98
317/321 | 0.02506990937493001 |  | 7.98
347 | 0.025226989007605 |  | 8.03
410 | 0.02419026343195 |  | 7.7
430 | 0.02425309528502 |  | 7.72
446 | 0.024033183799275 |  | 7.65
Gray Cast Iron | 0.0226194671052 |  | 7.2
Carbon Steel | 0.024661502329975 |  | 7.85
Copper | 0.02808583832229 |  | 8.94
Red Brass 230 | 0.027488935718125 |  | 8.75
[NAME] | 0.02676636940782 |  | 8.52
[NAME] | 0.02676636940782 |  | 8.52
Cu/Ni 706,710,715 | 0.02808583832229 |  | 8.94
Nickel Silver | 0.027488935718125 |  | 8.75
Alloy 200 | 0.027928758689615 | Nickel 200 | 8.89
Alloy 201 | 0.027928758689615 | Nickel 201 | 8.89
Alloy 400 | 0.027740263130405 | Monel 400 | 8.83
Alloy K-500 | 0.02657787384861 | Monel K500 | 8.46
Alloy 600 | 0.02645221014247 | Inconel 600 | 8.42
Alloy 601 | 0.0257610597587 | Inconel 601 | 8.2
Alloy 625 | 0.02651504199554 | Inconel 625 | 8.44
Alloy 718 | 0.025729643832165 | Inconel 718 | 8.19
Alloy 800 | 0.025132741228 | Incoloy 800 | 8
Alloy 800H | 0.025132741228 | Incoloy 800H | 8
Alloy 800HT | 0.025132741228 | Incoloy 800HT | 8
Alloy 825 | 0.02569822790563 | Incoloy 825 | 8.18
Alloy C-276 | 0.027865926836545 | Hastelloy C276 | 8.87
Alloy C-4 | 0.02714336052624 | Hastelloy C-4 | 8.64
Alloy C-22 | 0.027300440158915 | Hastelloy C-22 | 8.69
Alloy B-2 | 0.02896548426527 | Hastelloy B-2 | 9.22
Alloy 20 | 0.02544690049335 | [NAME] 20Cb-3 | 8.1
Alloy 904L | 0.025289820860675 | Uranus B-6 | 8.05
Alloy G-3 | 0.02607521902405 |  | 8.3
Alloy 36 | 0.02530506470923413 |  | 8.0548522677
Alloy 42 | 0.02547898267974434 |  | 8.1102120771
Alloy 52 | 0.02608769557653004 |  | 8.30397141
Columbium (Niobium) | 0.02687032644382594 |  | 8.5530905523
Copper | 0.02808775223739734 |  | 8.9406092181
Ferralium 255 | 0.02452243384193823 |  | 7.8057331254
Haynes 25 | 0.02869646513418304 |  | 9.134368551000001
Haynes 188 | 0.02817471122265245 |  | 8.968289122800002
Inconel X750 | 0.02600073659127494 |  | 8.2762915053
Invar | 0.02530506470923413 |  | 8.0548522677
Kovar | 0.02626161354704024 |  | 8.3593312194
Magnesium | 0.005478416071071308 |  | 1.7438339961
Molybdenum | 0.03130523469183605 |  | 9.964765692
Nickel 200/201 | 0.02791383426688714 |  | 8.8852494087
Multimet N155 | 0.02573985963550963 |  | 8.1932517912
Mu-Metal | 0.02652249050280553 |  | 8.4423709335
[NAME] | 0.02747903934061164 |  | 8.746849885200001
Permalloy 80 | 0.02739208035535654 |  | 8.7191699805
[NAME] | 0.02591377760601984 |  | 8.2486116006
Stainless Steel 400S | 0.02434851587142804 |  | 7.750373316000001
Stainless Steel 300 | 0.02521810572397904 |  | 8.027172363
Tantalum | 0.05233893360731001 |  | 16.66
Titanium 6AL4V | 0.01391343764081602 |  | 4.428784752
Titanium Grade 1 | 0.01413716694075 |  | 4.5
Titanium Grade 2 | 0.01413716694075 |  | 4.5
Titanium Grade 5 | 0.01413716694075 |  | 4.5
Titanium Grade 7 | 0.01413716694075 |  | 4.5
Tungsten | 0.06061041272280478 |  | 19.2928935759
Zirconium 702 | 0.0207345115131 |  | 6.6