Hi guys,
I am new to this forum and have a question.
I am not greatly experienced with Excel and I have been making a spending spreadsheet to keep a track of my finances.
So my columns are; "Month, purchase, payment method, category, value, notes"
I fill in this for example; February, Book, Bank Card, Personal, £15.00, A book for university"
I have next to the table a little set of Excel cells with the titles of "Category, Amount" and I basically wanted the amount cell for each category to populate when I enter something that matches that category.
I know it is supposed to be something like a VLOOKUP formula, but I honestly can't get it to work. I basically want to search the category column for the category, say "Food & Drink" and then return the value which is corresponding with that category - if that makes sense? And I want it to keep a running total for each category!
Sorry if I sound stupid!
I am new to this forum and have a question.
I am not greatly experienced with Excel and I have been making a spending spreadsheet to keep a track of my finances.
So my columns are; "Month, purchase, payment method, category, value, notes"
I fill in this for example; February, Book, Bank Card, Personal, £15.00, A book for university"
I have next to the table a little set of Excel cells with the titles of "Category, Amount" and I basically wanted the amount cell for each category to populate when I enter something that matches that category.
I know it is supposed to be something like a VLOOKUP formula, but I honestly can't get it to work. I basically want to search the category column for the category, say "Food & Drink" and then return the value which is corresponding with that category - if that makes sense? And I want it to keep a running total for each category!
Sorry if I sound stupid!
