Hi All,
I have the following table
<tbody>
</tbody>
And I have the following formula which works.
=SUMPRODUCT(B2:B4,C2:C4)/SUM(B2:B4)
What I want to do is include vlookups into the sumproduct to pick them 3 items up from a big table of items.
Thanks
Paul
I have the following table
A | B | C |
Item1 | 28 | 651 |
Item2 | 78 | 749 |
Item3 | 19 | 1403 |
<tbody>
</tbody>
And I have the following formula which works.
=SUMPRODUCT(B2:B4,C2:C4)/SUM(B2:B4)
What I want to do is include vlookups into the sumproduct to pick them 3 items up from a big table of items.
Thanks
Paul