Hi everyone,
I have 3 columns (J"ReOrderPoint Score", K"Inventory Status", L"Expected Shipment")
1(J). "ReOrderPoint Score" gives values like "Increase in Order", "Decrease in Order" or "Average" determined by other columns in the sheet.
2(K). "Inventory Status" which gives value either "Reorder" or "OnStock".
3(L). "Expected Shipment" which gives integer value based on the number of parts that we are expecting.
I'm trying to come up with the following :
1. column(M) that gives "RE" if Reorder Point Score" says "Increase in Order", Inventory Status says "Reorder"and "expected Shipment" has value 0.
2. column(N) that gives "GO"if Inventory Status is set to "Reorder" and Expected Shipment is 0.
The goal is to narrow down the products that I need to purchase and to see if I missed anything from the list of 5000 products. If anything else is easier than what I'm thinking, I'm open to your opinion as well.
Thanks as always,
Roshan
Bookmarks