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, Suffix extracted from product and names
Than add countifs and add no.
Than add countifs and add no.