Excel 2007 : Multiple VLOOKUP

[gentelmanjack]

Hello,

Searched EVERY WHERE, and cannot find a thing.
Can someone please help me?

Trying to match col A & B and both sheets and have col 3 on EX1 input on EX2.

I've read about INDEX, but VLOOKUP seems the easiest.

I can use VLOOKUP for 1 colums but not multiple.

Thanks

[JBeaucaire]

In C2 and copied down:

=SUMPRODUCT(--([EX1.xls]Sheet1!$A$2:$A$501=$A2), --([EX1.xls]Sheet1!$B$2:$B$501=$B2), [EX1.xls]Sheet1!$C$2:$C$501)

[gentelmanjack]

Thank you Jerry.
BTW I like your site.

[JBeaucaire]

Thanks, hope it's of use to you in your projects.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.