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...
Is it too hard for you? For it is too.
Some logical explanation required:
1. Sum of total <Product+Name> sold in Sales till current row like $A$1:$A1. & pick code from Inventory Codes.
2. Lookup for Inventory <Product+Name>.
Now,
Inventory <Product+Name> - Sales <Product+Name>
Let's say,
Inventory <Product+Name> = 100
Sales <Product+Name> = 99
Code continues unless it becomes equal to 100. Then it will be Over Stocked or Sold out.
3. Again do the same process but also check is <Product+Name> available or sold out, if sold out then go-to next code.
Note; Previous entries with previous codes must not be destroyed.
How can I translate this in Microsoft Excel? Need an expert
Some logical explanation required:
1. Sum of total <Product+Name> sold in Sales till current row like $A$1:$A1. & pick code from Inventory Codes.
2. Lookup for Inventory <Product+Name>.
Now,
Inventory <Product+Name> - Sales <Product+Name>
Let's say,
Inventory <Product+Name> = 100
Sales <Product+Name> = 99
Code continues unless it becomes equal to 100. Then it will be Over Stocked or Sold out.
3. Again do the same process but also check is <Product+Name> available or sold out, if sold out then go-to next code.
Note; Previous entries with previous codes must not be destroyed.
How can I translate this in Microsoft Excel? Need an expert