in C28:
=INDEX(A$3:A$21,MATCH(D28,Y$3:Y$21,0))
and fill down

"YS1107" wrote in message
...
I need help with cell reference in cells. In cells A3:A21 I have a list
of
store numbers and in cells Y3:Y21 I have scores. In cells D28:D32 I have
the
top 5 stores scores. I have figured out to get the top 5 scores to
populate
in cells D28:D32 by using the LARGE function =LARGE($Y$3:$Y$21,1). Now I
need
the have the stores numbers to populate in cells C28:C32 next to the
scores
in D28:D32. I have tried several formulas to get this to work with
success.
VLOOKUP,INDEX/MATCH. I need some help and direction.