Vlookup with a function?

[mashley]

I have several lists of products with the number of sales for each product. The first sheet is a total for several teams, the subsequent sheets are the individual teams. I need to be able to calculate, on the team sheets, the % of each product that each team is contributing to the total number. Each list is constanly changing and the products dont appear on the same row in each sheet. I am thinking something like vlookup but instead of a colum index number as the output, I need to enter the division forumla. Thanks.

 

[barry houdini]

I tried to convert to my actual columns and went down in flames, true columns are:
formula in T
Number being divided in R
Number divided by in R
Product name in C

Sorry, I missed out a crucial sheet reference

Try this in T2 copied down

=R2/INDEX(Master!R:R,MATCH(IF(C2="",C1,C2),Master!C:C,0)+(C2=""))

 

[mashley]

That worked great and then my brain melted. If you answer this one more question, I wont bother you anymore.
The first line of the first product is 11. Each product takes up 8 lines and the formula I need to use is on lines 11, 12, 15 and 16. The product name only appears in c11. What values would I replace in the formula to use this on lines 15 and 16?
Thanks for all your help.