Currently I get financial info broken down into accounts, the number accounts
may change every month. I have an index spreadsheet that lists every
possible account and what category it goes into.
Currently I do a Vlookup from the financial spreadsheet to my index to get
the category name on the financial spread sheet, then sumif at the bottom to
summarize, not a big deal really, but I have multiple spreadsheets I do this
on every month so I was wondering if there was any way possible to do this in
one step. Something like a sumif(vlookup(a1:a100,indextable
a1:b1000,2,false),categoryname,b1:b100) where a1:a100 is my account name
range and b1:b100 is my dollar amounts
I know the above doesnt work becacuse vlookup cant use a range, but its the
general gist of what I would like to do. I've done some neat things with
sumproduct, but since my index range is not the same size as my account
range, I know it wont work.
Is there some other neat trick to get this to work in one single equation?