Addictions
Board Regular
- Joined
- May 27, 2018
- Messages
- 60
- Office Version
- 365
Hi,
Can somnoe help or navigate me on how to solve this problem
I would want to originaly have a vlookup to return values from Table 2 in to Table 1, A, B, C columns. The problem is with duplicates vlookup will always return the first found value.
Any ideas to solve this?
Table 1
Table 2
Table 1
A B C D
1 Michael (90) (80) (60)
Table 2
A B
1 Michael 90
2 Michael 80
3 Ana 70
4 Michael 60
Can somnoe help or navigate me on how to solve this problem
I would want to originaly have a vlookup to return values from Table 2 in to Table 1, A, B, C columns. The problem is with duplicates vlookup will always return the first found value.
Any ideas to solve this?
Table 1
Michael | (90) | (80) | (60) |
Table 2
Michael | 90 |
Michael | 80 |
Ana | 70 |
Michael | 60 |
Table 1
A B C D
1 Michael (90) (80) (60)
Table 2
A B
1 Michael 90
2 Michael 80
3 Ana 70
4 Michael 60