think through how you want to coding the products first before generating actual code numbers. for example: a combination of alphabet and numbers like AXY3456.
sannin99(雷蒙咨询)
Then use Vlookup function to bring up product details based on code assigned/typed in.