Planning for 2025 budget

I have been using Randy’s Budget Builder for many years. Just today, I posted how I use it and an improvement to it here.

I add the columns to the Categories worksheet like @martha.rudkin indicates and then use the following formula in the first category under Jan 2025 column…

=arrayformula(iferror(vlookup($A2:$A156,{‘2025 Budget Builder’!$D$7:$D250,‘2025 Budget Builder’!$AY$7:$BJ250},match(BB$1:BM$1,‘2025 Budget Builder’!$AY$2:$BJ$2,0)+1, FALSE)))

This pulls the monthly budget I set up in my 2025 Budget Builder worksheet.

2 Likes