Thread: Question (about "if" and "lookup", I'm not sure)

Using your posted workbook, try this on Sheet1:

Code:

C2: =SUMPRODUCT((Sheet2!$A$2:$A$30&"_"&Sheet2!$B$2:$B$30=A2&"_"&B2)*
Sheet2!$G$2:$G$30)

Copy that formula down through C11.

Actually, this formula is shorter and less complicated:

Code:

C2: =SUMPRODUCT((Sheet2!$A$2:$A$30=A2)*(Sheet2!$B$2:$B$30=B2)*Sheet2!$G$2:$G$30)

Does that help?

I'm glad that worked for you...Thanks for letting us know!