Erin,

Oops. I didn't notice you said it needs to reference by month and year. Does that mean
that there are multiple entries for each person in sheet 2, with different months and years?
Your data doesn't show that. Should it just pull data by month and year, and ignore the
person's name?

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"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