Vlookup with duplicate values.

[Addictions]

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

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

 

[Addictions]

It should be:
I would want to originaly have a vlookup to return values from Table 2 in to Table 1, B, C, D columns.

 

[Fluff]

What version of Excel are you using? Please update you account details to show this.

 

[Addictions]

What version of Excel are you using? Please update you account details to show this.

Hi,

Updated, it is 365.
Many thanks

 

[Fluff]

Thanks for that.
If you have the filter function how about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I
1
2	Michael	90			Michael	90	80	60
3	Michael	80			Ana	70
4	Ana	70
5	Michael	60
6
7
Admin

Cell Formulas
Range	Formula
F2:H2,F3	F2	=TRANSPOSE(FILTER($B$2:$B$5,$A$2:$A$5=E2))
Dynamic array formulas.

 

[Addictions]

Thank you, but I do not have Filter function for some reason.

 

[Fluff]

Ok, you'll probably get it next month.
How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I
1
2	Michael	90			Michael	90	80	60
3	Michael	80			Ana	70
4	Ana	70
5	Michael	60
6
Admin

Cell Formulas
Range	Formula
F2:I3	F2	=IFERROR(INDEX($B$2:$B$5,AGGREGATE(15,6,(ROW($B$2:$B$5)-ROW($B$2)+1)/($A$2:$A$5=$E2),COLUMNS($F2:F2))),"")

 

[Addictions]

Thank you

 

[Fluff]

You're welcome.

 

[Addictions]

Ok, you'll probably get it next month.
How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I
1
2	Michael	90			Michael	90	80	60
3	Michael	80			Ana	70
4	Ana	70
5	Michael	60
6
Admin

Cell Formulas
Range	Formula
F2:I3	F2	=IFERROR(INDEX($B$2:$B$5,AGGREGATE(15,6,(ROW($B$2:$B$5)-ROW($B$2)+1)/($A$2:$A$5=$E2),COLUMNS($F2:F2))),"")

How would you specify whole column instead fo specifing range?. Instead of $B$2:$B$5 it would be a B column. The first row has headers.