=INDEX(Sheet2!C2:C1000,MATCH(1,(Sheet2!A2:A1000=A2 )*(Sheet2!B2:B1000=B2),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"maricelsy" wrote
in message ...

I have 2 columns... A & B that need to match with 2 other columns in
another sheet (Sheet2.A & Sheet2.B) before I add the values in column
C. I did SUMIF(A2:B1000;SHEET2.A2:B2;C2:1000) but it gives me a #VALUE
error. How should I write my formula?
I appreciate your help.


--
maricelsy
------------------------------------------------------------------------
maricelsy's Profile:
http://www.excelforum.com/member.php...o&userid=36383
View this thread: http://www.excelforum.com/showthread...hreadid=561543