Index & Match formula problem

[asyamonique]

Hello is there any way to fix below formula?
I placed the formulas by the columns J & K all the way down.
If column C datas are the same numbers my formula doesn't find two differnt names...
Many thanks.

[TABLE="width: 301"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]COLUMN B[/TD]
[TD]COLUMN C[/TD]
[/TR]
[TR]
[TD]Name 1[/TD]
[TD]12,000[/TD]
[/TR]
[TR]
[TD]Name 2[/TD]
[TD]12,000[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 291"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]COLUMN J[/TD]
[TD]COLUMN K[/TD]
[/TR]
[TR]
[TD]Name 1[/TD]
[TD]12,000[/TD]
[/TR]
[TR]
[TD]Name 1[/TD]
[TD]12,000[/TD]
[/TR]
</tbody>[/TABLE]



J3=

=IFERROR(INDEX($B$3:$B$8,MATCH(K3,$C$3:$C$8,0)),"")

K3=

=IFERROR(LARGE($C$3:$C$8,ROWS($1:1)),"")

 

[AhoyNC]

Try this array formula and drag down as needed.
Note: this formula must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	A	B	C	D	I	J	K	L
1
2
3		Name 1	12,000			Name 1	12000
4		Name 2	12,000			Name 2	12000
5		Name 3	11,500			Name 3	11500
Sheet

 

[asyamonique]

Thanks a lot

 

[asyamonique]

If column C datas cleared the Names are still remains not automaticly cleared on column J
Is there any way to fix that?

 

[asyamonique]

I did some alteration, fixed.
Thanks again.

=IF($K3="","",INDEX($B$3:$B$8,SMALL(IF($C$3:$C$8=$K3,ROW($C$3:$C$8)-ROW($C$3)+1),COUNTIF($K$3:K3,K3))))

 

[AhoyNC]

This should work if there are blanks in column C.

Excel Workbook
	B	C	D	I	J	K
3	Name 1	12,000			Name 1	12000
4	Name 2				Name 3	11500
5	Name 3	11,500
Sheet