Understand the instruction
A supplier sheet may contain several models, dimensions and finishes. Identify which variant the project actually selected before extracting a number. Retain units and source locations; flag ambiguous tables instead of filling the gap.