Hi Everyone,
Thanks in advance for your help
Please help to find the appropriate index match formula to combine the prices by percentage. I don't know if index/match is working with search.
1. I have to find "Sliced Straw Mexico" , "Sliced Straw Peru/Chile" and "Sliced Straw Mexico"
2. Need to make 50% of Mexico , 25% Peru/Chile and California 25% and sum up.
Also needs to be by plant, 1 column for Montreal, 2nd for Front Royal and 3rd for Vancouver'
Thanks for your help
Last edited by iasinschi; 10-30-2018 at 09:31 AM.
D21=if(d$20<>"",sumproduct((($c$7:$c$9=$c$7)+($c$7:$c$9=$c$8))*($d$6:$f$6=d$20)*($d$7:$f$9))*0.25+sumproduct(($c$7:$c$9=$c$9)*($d$6:$f$6=d$20)*($d$7:$f$9))*0.5,"") copy across
Thank you very much CARACALLA.
The formula works, but i have new data to dump every week. I need to select from a higher range of fruits and vegetables. I have attached the revised excel problem. I think I have to use FIND or SEARCH in combination with INDEX MATCH.
Thank you
Same formula with different range
B21=IF(B$20<>"",SUMPRODUCT((($A$3:$A$13=$A$7)+($A$3:$A$13=$A$8))*($B$2:$D$2=B$20)*($B$3:$D$13))*0.25+SUMPRODUCT(($A$3:$A$13=$A$9)*($B$2:$D$2=B$20)*($B$3:$D$13))*0.5,"") copy across
Last edited by CARACALLA; 10-29-2018 at 05:10 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks