Vlookup with sum function

[N0t Y0urs]

Not sure if I can do what I want but I think I want a sumif v lookup formula.

This is my scenario I have 3 columns in my range. First one being my reference number, my second column has a weekly value in it and my 3rd column is a running balance. So what I want is a running total of the weekly value at a reference point.

Let assume this i have 100 entries therefore each weekly value starts at 100 and doubles each line so I want the value at level 4 then it’s value is 3100

I’ve attached an image to assist
Any ideas

 

[Peter_SSs]

Just wanted to say I’ve thrown it into my big spreadsheet and it’s working perfectly and I understand the logic now as well.

Good news!

I would love to get my head around all excels capabilities as I think I could achieve some pretty awesome things if I had the know how

Stick around this forum for a while and you should learn plenty. ?‍?

 

[etaf]

I would love to get my head around all excels capabilities

Post any questions on the forum
Or maybe everynow and again have a look at the questions answered here, if you see one with title that may interest you , then see the solution

there are a lot of tutorials now on you tube, but often, until you have something to solve, you wont necessarily go through all the possible functions

I would perhaps look at
SUM's
COUNT's
IF's
Conditional formating
The order in which excel handles +-*/ operators , can easily give a wrong result
some of the text functions, like left/right/mid
lookups - vlookup, index/match
iferror

or search google for something like - the top excel functions