Use Match or Vlookup?
Hi Erin
Try the following formula in Sheet1! E2 copied down/across:
=INDEX(Sheet2!E$2:E$4,MATCH(1,(Sheet2!$A$2:$A$4=Sh eet1!$A2)*(Sheet2!$B
$2:$B$4=Sheet1!$B2)*(Sheet2!$D$2:$D$4=Sheet1!$D2), 0))
this is an array formula which must be entered with Ctrl+Shift+Enter
(ie not with simply Enter - excel will surround with curly braces {}
if it has worked).
Hope this helps!
Richard
On Feb 25, 8:49 pm, ECLynn <ECL99 wrote:
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
|