floridagunner
Board Regular
- Joined
- Jul 20, 2007
- Messages
- 60
Hello I need some help adjusting a formula.
I have a worksheet named (FA_Split_Master_July1007). Which has this information:
(code)
A B C
12345 TOM
12345 KYLE
12345 DAN
12345 ALEX
67899 TAYLOR
67899 KURT
88425 MIKE
(/code)
In another sheet I have this Information:
(code)
A P
12345
12345
12345
12345
12345
12345
12345
12345
67899
67899
67899
67899
(/code)
I applying this formula to bring in the corresponding names:
(code)=INDEX(FA_Split_Master_July1007!$A$1:$C$57670,SMALL(IF(FA_Split_Master_July1007!$A$1:$C$57670=$A2,ROW(FA_Split_Master_July1007!$A$1:$C$5767)),COUNTIF($A$2:A2,A2)),3)(/code)
However this is the result that I get back:
(code)
A P
12345 TOM
12345 KYLE
12345 DAN
12345 ALEX
12345 #NUM!
12345 #NUM!
12345 #NUM!
12345 #NUM!
67899 TAYLOR
67899 KURT
67899 #NUM!
67899 #NUM!
(/code)
What I need the formula to do is this:
(code)
A P
12345 TOM
12345 KYLE
12345 DAN
12345 ALEX
12345 TOM
12345 KYLE
12345 DAN
12345 ALEX
67899 TAYLOR
67899 KURT
67899 TAYLOR
67899 KURT
(/code)
Does anybody know what I could change in my formula to make it work?
Thanks
I have a worksheet named (FA_Split_Master_July1007). Which has this information:
(code)
A B C
12345 TOM
12345 KYLE
12345 DAN
12345 ALEX
67899 TAYLOR
67899 KURT
88425 MIKE
(/code)
In another sheet I have this Information:
(code)
A P
12345
12345
12345
12345
12345
12345
12345
12345
67899
67899
67899
67899
(/code)
I applying this formula to bring in the corresponding names:
(code)=INDEX(FA_Split_Master_July1007!$A$1:$C$57670,SMALL(IF(FA_Split_Master_July1007!$A$1:$C$57670=$A2,ROW(FA_Split_Master_July1007!$A$1:$C$5767)),COUNTIF($A$2:A2,A2)),3)(/code)
However this is the result that I get back:
(code)
A P
12345 TOM
12345 KYLE
12345 DAN
12345 ALEX
12345 #NUM!
12345 #NUM!
12345 #NUM!
12345 #NUM!
67899 TAYLOR
67899 KURT
67899 #NUM!
67899 #NUM!
(/code)
What I need the formula to do is this:
(code)
A P
12345 TOM
12345 KYLE
12345 DAN
12345 ALEX
12345 TOM
12345 KYLE
12345 DAN
12345 ALEX
67899 TAYLOR
67899 KURT
67899 TAYLOR
67899 KURT
(/code)
Does anybody know what I could change in my formula to make it work?
Thanks