Index/Match combining with Search (partial text string)

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