Excel GODs please help me!

[nickkim88]

Table A and Table B has the same information.

Are there anyway you can fill in column "M" with formula?

 

[Vogateer]

For M3, filled down:

=LET(warehouse_col, MATCH("Warehouse " & I4, $E$2:$G$2, 0),SUMIFS(INDEX($E$3:$G$14, ,warehouse_col), $C$3:$C$14,L4, $B$3:$B$14,K4))

 

[nickkim88]

For M3, filled down:

=LET(warehouse_col, MATCH("Warehouse " & I4, $E$2:$G$2, 0),SUMIFS(INDEX($E$3:$G$14, ,warehouse_col), $C$3:$C$14,L4, $B$3:$B$14,K4))

thanks so much but this formula gives me wrong qty??

 

[nickkim88]

thanks so much but this formula gives me wrong qty??

actually, your formula is right, i just had to push up the column! thanks so much!

 

[Vogateer]

Excellent! I think you can mark a solution for this if you like, and you can mark this question as solved.