Hi,
I have created this nice worksheet where I add all my costs, and then the numbers gets worked on and it splashes some nice grafs telling me I can't afford splurging more on expensive ice-cream.
The thing is I would like to have some way to calculate what I've spent this far, and compare it to how much I have left to spend the coming year.
So what I'm looking for is a way to search a column, find a value, lets say "Bike", then grab the adjoining number. Do this for the column and present me the number.
In my attached example I would for instance want to search B2:B17 for the string Bike, grab the numbers from the corresponding C-columns, add them and subtract from the value in C25.
Might be easier said than done?
Any help much appreciated, Thanks! :)
Bookmarks