Help with Lookup

[stashman]

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?

 

[DanteAmor]

Try this:

varios 17may2022.xlsm
	A	B	C	D	E	F	G	H
1	Month	P&LLine	Amount			Month	P&LLine
2	Jan	Rev-HW	100			Jan	Rev-HW	350
3	Jan	Rev-HW	250			Feb	Rev-HW	340
4	Feb	Rev-HW	200
5	Feb	Rev-HW	140
Hoja8

Cell Formulas
Range	Formula
H2:H3	H2	=SUMPRODUCT(($A$2:$A$5=F2)*($B$2:$B$5=G2)*($C$2:$C$5))

 

[stashman]

Worked like a charm.....THANK YOU!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.