Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup or Match | Excel Discussion (Misc queries) | |||
Vlookup or Match | Excel Discussion (Misc queries) | |||
To VLOOKUP more than one possible match | Excel Discussion (Misc queries) | |||
vlookup second match | Excel Discussion (Misc queries) | |||
Match or vlookup? | Excel Worksheet Functions |