I have 2 cloumns of data and I need to find a name in a column and then report the name at the top of that column. A simple Example.
____A__________________B
1. Als' team________Jo's team
2. Fred 66____________ Julie 98
3. George 69__________ Jenny 99
4. Brad 80____________ Eddie 54
George * _____Here I need it to look up in the top section find the name (eg.George) and Repot either Al's Team or Jo's Team which ever the agent belongs to.
Don't worry about the scores I can remove them I just it need to search the name to find the team name.
Thanks for any help
Andreas
____A__________________B
1. Als' team________Jo's team
2. Fred 66____________ Julie 98
3. George 69__________ Jenny 99
4. Brad 80____________ Eddie 54
George * _____Here I need it to look up in the top section find the name (eg.George) and Repot either Al's Team or Jo's Team which ever the agent belongs to.
Don't worry about the scores I can remove them I just it need to search the name to find the team name.
Thanks for any help
Andreas
Last edited: