On sheet2 the names are in column C
"Jason Morin" wrote:
Assuming the names are listed in col. C in Sheet2:
=SUMPRODUCT((Sheet2!$C$1:$C$20=B1)*(Sheet2!
$D$1:$D$20="yes"))
HTH
Jason
Atlanta, GA
-----Original Message-----
I am trying to lookup 2 values in sheet2 which should go
into sheet1. I'll
try to explain.
Sheet 1 needs to look up the name of a person that is in
both sheets.
Sheet2 contains all the infomration and the name appears
more than once.
I want the cell too automatically look up the name.
After that it needs to look up for the number of "yes"
values that are in
sheet 2 clumn D linked to the name on sheet 1 column B
I've tried so many different things but not sure how it
should be
Hope this makes sense
.
|