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.

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.

WORKS PERFECTLY THANK YOU

"Bob Umlas" wrote:

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.

.

Now is there a way to break a tie? as of now it shows on one store twice
instead of listing the two seperate stores. I made two stores have the exact
scores and it list the store with the lower number twice. For example I have
store 598 and store 698 both with a score of 100% but in the ranking of the
stores it shows store 598 twice instead of 598 then 698. And if this is
possible can we have it list it in descending order? 598 first and 698
second? Here is what it looks like now:

C28 D28
598 100%
598 100%

I need it to look like this

C28 D28
598 100%
698 100%

If this is not possible I can live without the tiebreaker, I suppose. :)
Thanks for your HELP BOB!!

"Bob Umlas" wrote:

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.

.