Table 54b Excel [patched] - Astm

Use INDEX and MATCH or XLOOKUP with approximate match:

ASTM Table 54B (commonly cited in ASTM standards for steels and metallic materials) is a tabulated reference listing chemical composition limits, mechanical-property requirements, or tensile/impact test ranges for specific material grades or heat treatments. Its exact contents and context vary by the specific ASTM standard that includes a "Table 54B" label (ASTM standards are numerous and independently numbered). Astm Table 54b Excel