I am building a budget calendar where I have a data sheet as worksheet 1, followed by 12 months worksheets. I am wanting to have each months expenses build the expenses from the data sheet 1 into one column based on the criteria that there is an expense associated with that month, and then return the amount in the next column. This will be used to confirm I have added the items somewhere on each months budget. I've been trying different index-match formulas but keep getting errors.
I have attached a sample of what I am working on. [budget example.xlsx]
Your help would be appreciated.
Bookmarks