training excel vba - INDEX, MATCH AND LARGE FORMULA

HI


I am working on a sheet with 2 columns and organizing these in a separate sheet.

firstly I am organizing in ASCENDING ORDER a long list with the following:

=LARGE(IF(('List clients'!$F$3:$F$482>" "),'List clients'!$K$3:$K$482),K)

secondly I am retreiving the data of the nearby columns in order to match the ascending values with the following:

=INDEX('List clients'!$A$3:$A$482,MATCH('NAME OF SHEET WHERE THE LIST IS'!$PK,'List clients'!$K$3:$K$482,0),1)


The problem I have is that I have a few amounts in the ascending column that perfectly match. When that happens the Index and Match formula (second above) cannot retreive the correct names but retreive the first name in th elist, twice.

I will try to explain better:

If the original file is as below,

column A Column B

CLIENT X 558
CLIENT A 555
CLIENT B 555
CLIENT 5 560


I apply the first formula above to organize the column B, and the second formula to retreive the information in column A accordingly.

unfortunately instead of getting the following result:

CLIENT Y 560
CLIENT X 558
CLIENT A 555
CLIENT B 555


I obtain the below, which is not correct:

CLIENT Y 560
CLIENT X 558
CLIENT A 555
CLIENT A 555

in other words CLIENT A is repeated twice and CLIENT B ( with same reference number, 555) does not appear at all.

Is there a way to solve this matter?

Kind Regards
yanti