Hi Guys,
May I ask you some help regarding the File in attached please?
I have tried to add it a Sumproduct Function in the TAB Consumption log but I cannot make it work,
I would like the function to find back the value in the Sheet CONSUMED DATA based on article name and Week number,
Many thanks in advance for your help!
Regards,
Stef
Last edited by St3ff3ns; 09-11-2015 at 04:56 AM.
Use E6=IF($A6="","0",SUMPRODUCT(('CONSUMED DATA'!$D$2:'CONSUMED DATA'!$D$294=E$5)*(INDEX('CONSUMED DATA'!$B$2:$B$710,MATCH($A6,'CONSUMED DATA'!$A$2:$A$710,0))))) and drag down.
Formula:
Please Login or Register to view this content.
Last edited by shukla.ankur281190; 09-11-2015 at 04:29 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hi, Thanks for rep man!!! hope the problem now have been solved please mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks