If value in column A, display content in same row column B

Good evening
in Column "C" to handle ties

=A1+ROW()/100000

in E

=INDIRECT("B"&MATCH(LARGE($C$1:$C$4,ROW());$C$1:$C$4;0))

instead of $C$4, use the number of the last row of the data

LARGE($C$1:$C$4,ROW()) to obtain the nth largest value with ROW()

MATCH to get the row number where the data is located

INDIRECT to get the data from column B

Hello Vaucluse and Yclic,

Thank you for your 2 responses. I managed to make both of your solutions work in the exact case I proposed to you.

I couldn't apply it as it is in my spreadsheet for the following reason. In fact, I was stuck because of VLOOKUP (and seemingly the INDIRECT function in the second solution you proposed) because for them to work, the value being searched must be the leftmost in the search range.

""""
Important: With VLOOKUP, the column that contains the value or cell reference you are searching for must be the leftmost column in the range.
https://support.office.com/en-us/article/Looking-up-values-using-the-VLOOKUP-INDEX-or-MATCH-function-7144ef3f-e322-4f95-9e96-f1d743270438
"""""
This was indeed the case in my example above but not in my spreadsheet which is more complex and organized differently (columns A and B are reversed).

I ended up using a combination of the INDEX and MATCH functions to work around this (which is what was advised in the case VLOOKUP was not applicable).

=INDEX($A$1:$A$4,MATCH(D1,$B$1:$B$4,0),1)
"
https://www.excel-pratique.com/en/functions/index_match.php
"

(thanks to Yclic for the trick of adding decimals which allowed me to manage large values of different ranks but with equal values).

There you go, I'm not sure if it's clear but I hope it can help others. In any case, it's all good for me.

Thanks again.