Hello Excel Gurus,
I am having some difficulty and looking for some help. I am trying to pull together an expense report from several different locations. Unfortunately not all of the locations have the same accounts or are in the same order. I have compiled a list of the accounts on sheet 1 but now am having issues in trying to create a formula that will look at what I have in A1 on Sheet 1, and compare that to what I have in Sheets 2,3 and 4 and if there is a match pull in and sum those numbers for those months.
A B C
<tbody>
</tbody>
So in Sheet 1 I'm having trouble getting the formula right to find and then sum up the information in Sheets 2,3,4.
Thanks for the help.
I am having some difficulty and looking for some help. I am trying to pull together an expense report from several different locations. Unfortunately not all of the locations have the same accounts or are in the same order. I have compiled a list of the accounts on sheet 1 but now am having issues in trying to create a formula that will look at what I have in A1 on Sheet 1, and compare that to what I have in Sheets 2,3 and 4 and if there is a match pull in and sum those numbers for those months.
A B C
Sheet 1 | Jan-18 | Feb-18 | |
Total Expenses | |||
500185 - Interior Paint | |||
500225 - Landscaping | |||
500140 - Gas & Electric | |||
500210 - Janitotial CAM | |||
Sheet 2 | |||
Expenses | |||
500225 - Landscaping | 300 | 350 | |
500140 - Gas & Electric | 500 | 400 | |
Sheet 3 | |||
Expenses | |||
500185 - Interior Paint | 50 | 600 | |
500140 - Gas & Electric | 350 | 375 | |
500210 - Janitotial CAM | 125 | 125 | |
Sheet 4 | |||
Expenses | |||
500225 - Landscaping | 200 | 200 | |
500210 - Janitotial CAM | 150 | 150 |
<tbody>
</tbody>
So in Sheet 1 I'm having trouble getting the formula right to find and then sum up the information in Sheets 2,3,4.
Thanks for the help.
Last edited: