Using Index & Match with the Large function

Hello All

I have a spreadsheet which contains a Currency (colA), Number (colB) and HighRate (colC).

I need to create a template so that when the data in these columns is updated then the spreadsheet will automatically do the following...

- find the largest value in colB and pull it across along with the identifiers in A and C.
- then find the second largest in B and pull across identifiers
- and so - hence sorting colB by largest to smallest value and then pulling across the corresponding identifiers.

I can do this with

=INDEX($A$3:$A$27,MATCH(LARGE($B$3:$B$27,ROW()-ROW($F$2)),$B$3:$B$27,0))

BUT it doesn't work if I have more than one value the same in ColB i.e 3 rows of the number 2 !

Any improvements to the code or suggestions to get it working would be greatly appreciated. File attached....

Thanks
JXH