enter value if 2 criteria are met

  • Thread starter Thread starter clcnewtoaccess
  • Start date Start date
C

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,
 
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.
 
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
 
Back
Top