enter value if 2 criteria are met

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,
 
C

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.
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top