How do I combine numbers and names and only the name appears? (NEW)

Question

Hello everybody! I have a problem that I don't know how to solve and I would appreciate any help. I want to classify my teachers and I have two tables: one with their names and their scores (numbers), it's like a game. In the other table, I have the classification: to the function work, it needs numbers, and I want that the table shows the teacher associated. What type of training should I use? I have already tried the TEXT, CONCAT and CONCATENATE functionS

Thank you for your attencion!

EXAMPLES:
Teacher 1 has 1200 points. I use the funtion LARGE and it goes to "1" and appears his name.

Answer 1

No, that's completely diferent 😥Anyone help me!

Answer 2

Something like this?

=XLOOKUP(D2, B2:B7, A2:A7)

Answer 3

Of couse, watch the mensage again please, I had already updated.

Answer 4

Please explain in more detail what you want, preferably with some examples.