Have database of GL transactions where i have mapped the P&L line affected. It has following columns: Month, Financial report line, Amount
There are several entries for same financial report line in specific month (so would need sum).
Trying to do lookup where I could feed financial report by looking up intersection of the month and financial report.
Month P&L Line Amount
Jan Rev-HW 100.00
Jan Rev-HW 250.00
Feb Rev-HW 200.00
Feb Rev-HW 140.00
I feel like i should be using match or index or vlookup...getting confused. At the intersection of Jan & Rev-HW, i would want the answer to be 350.00 At the intersection of Feb & Rev-HW, answer should be 340.00
Is there simple solution?
There are several entries for same financial report line in specific month (so would need sum).
Trying to do lookup where I could feed financial report by looking up intersection of the month and financial report.
Month P&L Line Amount
Jan Rev-HW 100.00
Jan Rev-HW 250.00
Feb Rev-HW 200.00
Feb Rev-HW 140.00
I feel like i should be using match or index or vlookup...getting confused. At the intersection of Jan & Rev-HW, i would want the answer to be 350.00 At the intersection of Feb & Rev-HW, answer should be 340.00
Is there simple solution?