Use Match or Vlookup?
Am I the only one that sees that these are different:
SMG Smith, George
STR Rayan, Steve
HVJ Johnson, Howard
Smith, George
Rayan, Steve
Johnson, Howard
If the first group is consistent with a 3 character string in front of the
name:
=SUMPRODUCT(--(Sheet2!$A$2:$A$4=$A2),--(Sheet2!$B$2:$B$4=$B2),--(Sheet2!$D$2:$D$4=MID($C2,5,255)),Sheet2!E$2:E$4)
Biff
"T. Valko" wrote in message
...
I kind of figured the space would cause a line break and &*!# things up!
Here it is again split into bite sized chunks:
=SUMPRODUCT(--(Sheet2!$A$2:$A$4=$A2),
--(Sheet2!$B$2:$B$4=$B2),
--(ISNUMBER(SEARCH(MID($C2,FIND(" ",$C2)+1,255),
Sheet2!$D2:$D4))),Sheet2!E2:E4)
Biff
"T. Valko" wrote in message
...
Try this:
Entered in Sheet 1 cell D2:
=SUMPRODUCT(--(Sheet2!$A$2:$A$4=$A2),--(Sheet2!$B$2:$B$4=$B2),--(ISNUMBER(SEARCH(MID($C2,FIND("
",$C2)+1,255),Sheet2!$D2:$D4))),Sheet2!E2:E4)
Copy across then down
Biff
"ECLynn" <ECL99 wrote in message
...
I have 2 seperate sheets. I want to pull the accuracy rates (Acc%1 and
Acc%2)
from sheet #2 to sheet #1- it needs to reference by month and year. How
can I
do this? Help!
Sheet 1
A B C D E
F
Year Month TSR Name Acc % 1 Acc%2%
2 2006 7 SMG Smith, George
3 2006 7 STR Rayan, Steve
4 2006 7 HVJ Johnson, Howard
Sheet 2
A B C D
E F
Year Month1 EE# TSR Acc % 1 Acc % 2
1 2006 7 32958 Smith, George 17.9% 74.3%
2 2006 7 32558 Rayan, Steve 5.9% 98.1%
3 2006 7 13538 Johnson, Howard 88.0% 90.5%
Thanks!
--
Erin
|