Not Sorting Problem?
 

I have a list of people how have taken physical fitness test (pt) and
all of their results. In order to get their proper percentage, excel
looks up the data on a chart on 'sheet 2'. Now when I try to sort this
by the overall avg score, excel won't sort it at all. I have tried
selecting all columns, just some of them, header, no header. I don't
know what i'm missing. I think maybe my formulas are interfering with
the sort procedure. I would be happy to email anyone the spreadsheet if
you would like to try and sort it.

Thanks for all your help. I only have this spreadsheet now because of
your guys help!

mitch