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?
Bookmarks