Using Index/Match Function for a Weighted Average Formula Depending on Instance Returned?

So I use the Index/Match function to look up certain values based on certain text. Now, what I want to do is based on a certain text, create a weighted average formula that will multiply a higher weight such as 0.5 to the number returned by the first match of the formula, then multiply a smaller weight such as 0.25 to the second number matched.

Is it possible to do this in excel? Can excel skip the 1st match of a text and move on to the second match and return that value instead?

Post a sample workbook with examples of what you want to achieve, then we can work out if it can be done.

Pete

Book3.xlsx

Ok so this book provides a sample of the data.

So say I want to match the word "Toronto"

So excel will find the first match in cell B20. Then I want to take the corresponding number in H20. I want to assign a weight to that number say 0.5. Then I would like excel to move on to the next match of "Toronto" in cell B51. Then again take the corresponding number in H51 and assign a different weight such as 0.25 to that number. And continue on as I would like.

Can excel do this?

Any ideas if its possible?

.

Your file attached.

.