Lookup - two criteria

[carlito2002wgn]

Hi All,

I have two sheets, "Total Budget" and "Calculations"

Rows and Columns for lookup in Total Budget are Row 2 and Column C
Columns to find lookup values in Calculations are C,D and L

Here is what I want to do:

I want to return the value in Column L of the Calculations sheet to cells G3:U100 when I match is found.
The lookup criteria are Row 2 and Column C in the Total Budget, and the lookup ranges are Columns C and D in Calculations. The result that I want returned is from Column L in Calculations

In the example file (attached) I populated cell I10 with what I want to see there. I just referenced the cell from where the data should come, but I need a lookup formula that will be able to populate all of G3:U100.

All help is greatly appreciated!!

[Bo_Ry]

Please try at G2

=SUMIFS(Calculations!$L$4:$L$327,Calculations!$C$4:$C$327,G$2,Calculations!$D$4:$D$327,$C3)

[carlito2002wgn]

Please try at G2

=SUMIFS(Calculations!$L$4:$L$327,Calculations!$C$4:$C$327,G$2,Calculations!$D$4:$D$327,$C3)

This is perfect. I don't know why I sometimes overcomplicate things so much. Thank you, Bo_Ry!