Index and match functions for duplicate values

I COULD USE SOME HELP FIGURING OUT A FORMULA FOR CELLS C31:C35 ON THE ATTACHED SPREADSHEET I CREATED. (SHEET TAB 4-7-12) I AM TRYING TO SORT MY REFUNDS BY STORE NUMBER FROM COLUMN "A". I HAVE TWO STORES THAT HAVE 0.00% REFUNDS SO THE FORMULA I WROTE IS DUPLICATING THE STORE NUMBER. I AM PRETTY NEW TO EXCEL AND JUST CAN'T SEEM TO FIGURE IT OUT. THE FORMULA I USED IS

=INDEX($A$4:$A$20,MATCH(D31,$J$4:$J$20,0))

i HAVE A FEALING IT HAS TO DO WITH THE MATCH FUNCTION

CAN ANYONE HELP ME?

Try this in C31 with CTRL+SHIFT+ENTER, rather than just ENTER

Please Login or Register  to view this content.

Then copy down.