Try this one. See if you are good!

[Ckinglam]

I have sorted numbers from 1 to 53 in order based on
total scores. I want to create a cell in which it would
for say. Pick up the particular cell which results is 1.
Then from that cell, it would pick the particular cell
which has their name that is on the same row but
different column. So the goal is to display the name from
the original column in the box. I want the word to appear.

I don't mean no harm from the Subject. Just want to catch
your attention! hehe thanks!

 

[Arvi Laanemets]

Hi

Let you have your numbers to be in range A2:A54 (no order is required, but
you can have one) and according responses in column ... let's it be column
D.
And the key value is entered into cell F1 per example. Then the formula to
return response to value in F1 is:
=VLOOKUP(F1,A2:A54,4,FALSE)
With response values in column B the formula will be:
=VLOOKUP(F1,A2:A54,2,FALSE)
etc.

About your subject - LOL