I have a sheet where we calculate usage of an ingredient we use every day based on process orders.
Daily Ingredient Usage
The SAP GI can change if I fix a process order (didn't issue enough flour for the target)
I need a vlookup (maybe an IF) that will lookup the date on above spreadsheet, find the corresponding date on "Process Order Report" and ingredient # I want, find it's actual qty and add it all together on column E above (except set as a negative).
PROCESS ORDER REPORT (btw, there is a start date column it's just over on AX so I couldn't copy it)
Daily Ingredient Usage
The SAP GI can change if I fix a process order (didn't issue enough flour for the target)
I need a vlookup (maybe an IF) that will lookup the date on above spreadsheet, find the corresponding date on "Process Order Report" and ingredient # I want, find it's actual qty and add it all together on column E above (except set as a negative).
PROCESS ORDER REPORT (btw, there is a start date column it's just over on AX so I couldn't copy it)
Last edited by a moderator:
