I'm using Google Spreadsheets to manage my shared expenses with my girlfriend. It looks like this:
| Who | What | Category | When | Amount | | Gui13 | Vegetables | Meals | October 2012 | 26€ | | GF | AT&T | Multimedia | October 2012 | 30€ | ...
Now, I'd like to categorize automatically the expenses, meaning autofill the "Category" column according to what's in the "What" column.
I have an extra sheet where I have 2 columns indicating which value should be categorized as this or that:
| What | Category | | Vegetables | Meals | | Wine | Meals | | AT&T | Multimedia | ...
What I want to do is:
- find if the "What" cell content is found in the 2nd sheet
- if yes, fill the category with the content of the cell of the 2nd sheet
- if no, nothing
I couldn't figure how to do that with GDocs. I think it would involve
INDEX, but I'm not sure. Any idea?