I always have problems with the sumproduct function. I need some assistance. I have two variables to look up and return an "X" if true. I want the sumproduct function to tell me which companies use which part. I have all the columns/rows set up as follows. I just can't get sumproduct to return an X for me.
Worksheet 1
Part Description Ford GM Chrysler Toyota
a red X X
b yellow X
c green X
d blue X X
Worksheet 2 looks like this:
Part Company
a Ford
a GM
b Chrysler
c Chrysler
d Ford
d Toyota
Thanks in advance,
Dan
P.S. Let me know if I can clarify. It's difficult describing the situation.
Worksheet 1
Part Description Ford GM Chrysler Toyota
a red X X
b yellow X
c green X
d blue X X
Worksheet 2 looks like this:
Part Company
a Ford
a GM
b Chrysler
c Chrysler
d Ford
d Toyota
Thanks in advance,
Dan
P.S. Let me know if I can clarify. It's difficult describing the situation.