Vlookup needs to cover entire column, formula quits on me.

[TheBigRelish]

hello all,

I was given a helpful formula

=IFERROR(VLOOKUP(A3,$B$6:$D$9,3,0),"")

It works, but for a very limited amount. It will only add each from Col B once. I will be adding to this excel as the fiscal month carries on. I attempted to change $B$6:$D$9 to $B$6:$D$150 to cover a certain area of the spreadsheet,but it doesnt work.BudgetTracker2012.xlsx

I hope this makes sense.

[JBeaucaire]

I think you're using the wrong function... Use a SUMIF and just include a large enough starting range as to not have to worry?

=SUMIF($B$6:$B$10000, B$3, $D$6:$D$10000)

[TheBigRelish]

Bad thing is I am new at excel, good thing is your formula worked perfect. Thanks for the help.

[JBeaucaire]

I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.