Y
YS1107
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 D2832 I have the
top 5 stores scores. I have figured out to get the top 5 scores to populate
in cells D2832 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 D2832. I have tried several formulas to get this to work with success.
VLOOKUP,INDEX/MATCH. I need some help and direction.
store numbers and in cells Y3:Y21 I have scores. In cells D2832 I have the
top 5 stores scores. I have figured out to get the top 5 scores to populate
in cells D2832 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 D2832. I have tried several formulas to get this to work with success.
VLOOKUP,INDEX/MATCH. I need some help and direction.