I have a forecast file that I did some tweaking so that the quantities are cumulative
Basically what I want to do is determine by which week a SKU depletes
I intend to do this via the method shown in my sample data
For step 1 I can use MATCH
For step 3 I should be able to derive it using the output from step 2 using the MATCH and COLUMN function
Only problem is, I cant get the MATCH function to work for step 2 since from what I understand, MATCH only works for exact figures and Hlookup wont work
What do I do?
Bookmarks