enter value if 2 criteria are met

[clcnewtoaccess]

excel 2003.
I need to return a value from cell C2 in column H2 if the value in cell A2
matches column F2 and the date in column B2 matches the date in column G2.
If there is not a match then return 0. (also needed for D and I but I can
take care of that if you can help me with the first one)
sample data:
A B C D E
F G H
015-0121 4/27/2010 10 25.00 015-0121
4/27/2010

Thanks,

 

[Brad]

=IF(AND(A2=F2,B2=G2),C2,0)

 

[clcnewtoaccess]

is there a way to do a vlookup for the value of C2 if both A2 matches F2 and
B2 matches G2? I am having trouble with this formula working for the large
amount of data that I have. I could send you the spreadsheet if it would
help.

 

[Eduardo]

Hi,

=sumproduct(--(A2=$F$2:$F$1000),--(B2=$G$2:$G$1000),$C$2:$C$1000)

formula will look in column F and G if any value match what is in A2 and B2
and will bring C

 

[clcnewtoaccess]

Thank you this worked great, would you tell me what the -- is for?

 

[Eduardo]

Hi,
look into this web page it has a complete explanation of sumproduct and the
unary operator to ignore errors

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

thanks for the feedback