copy values from column if duplicateds finded

[edude]

Hi, I want to find duplicates from Ref A in ref B column. If a duplicate is found in B6 for example (the first one) I want to write in E2 the value from D6, in E3 the value from D5,in E4 the value from D3, E5 should be empty because the are no duplicates...
Can any of you wise savants help me out?

 

[Domenic]

First, when posting sample data, please either simply copy/paste or use the xl2BB add-in. Otherwise we won't be able to copy and paste the data from an image into a sample workbook so that we can come up with a solution and test it. Also, it always helps to provide the actual expected results (in your example the results for Column E), in addition to your written explanation. It makes things a lot clearer, and it's quicker to understand.

Now, as far a solution, try the following...

edude.xlsm
	A	B	C	D	E
1	Ref A	Ref B		Values Ref B	Values Ref A
2	1	18		45	25
3	2	3		66	34
4	3	6		45	66
5	4	2		34
6	5	1		25
7	6	6		86	45
8	7	8		23
9	8	57		166	23
10	9	9		444	444
11	10	10		68	68
Sheet1

Cell Formulas
Range	Formula
E2:E11	E2	=IFERROR(INDEX($D$2:$D$11,MATCH(A2,$B$2:$B$11,0)),"")

Hope this helps!

 

[edude]

First, when posting sample data, please either simply copy/paste or use the xl2BB add-in. Otherwise we won't be able to copy and paste the data from an image into a sample workbook so that we can come up with a solution and test it. Also, it always helps to provide the actual expected results (in your example the results for Column E), in addition to your written explanation. It makes things a lot clearer, and it's quicker to understand.

Now, as far a solution, try the following...

edude.xlsm
	A	B	C	D	E
1	Ref A	Ref B		Values Ref B	Values Ref A
2	1	18		45	25
3	2	3		66	34
4	3	6		45	66
5	4	2		34
6	5	1		25
7	6	6		86	45
8	7	8		23
9	8	57		166	23
10	9	9		444	444
11	10	10		68	68
Sheet1

Cell Formulas
Range	Formula
E2:E11	E2	=IFERROR(INDEX($D$2:$D$11,MATCH(A2,$B$2:$B$11,0)),"")

Hope this helps!

Thank you internet friend!

 

[Domenic]

You're very welcome, cheers!