Forum Discussion
Lookup with 3 Criterias and return next available Product Code from another sheet
I have two sheets Sales <tblSales> Inventory<tblInventory> In sheet inventory I have14 columns data. But I am interested in column Code. It is auto generated. Like WT-B-1 for same...
Like WT-B-1 for same product but if same new stock purchase code auto assigned will be WT-B-2.
Do you mean WT-B is the unique product code and suffix -1,-2 are purchase batch？
Do you mean WT-B is the unique product code and suffix -1,-2 are purchase batch？
Yes dear,
In sheet inventory, there is a list of products with unique Id<Codes> which is also auto calculated. For ease, I am attaching file link so you can analyze yourself.
https://1drv.ms/x/s!AtF-LIDedF0Hxi3bRybMzmukwz84?e=UqAUGE
In sheet inventory, there is a list of products with unique Id<Codes> which is also auto calculated. For ease, I am attaching file link so you can analyze yourself.
https://1drv.ms/x/s!AtF-LIDedF0Hxi3bRybMzmukwz84?e=UqAUGE