I can understand that you are very focused on the way you have always worked but data validity is going to be more accurate for data entry, easy to see, easy to correct and easily expandable.
In the sample below you can choose the item from a drop down list, I have extended the validity to only row 41 for this sample. One of the sheets includes the item only, the other includes the code and the item name. The Validity sheet can be extended but you need to extend the range in Data > Validity
DataValidity124836.ods (13.6 KB)