Sorting

[Khoori7]

Whenever i try to sort name from A-Z my calculations gets messed up for some reason, like my Average and etc I've added my excel worksheet in the attachment to get a better idea of what I'm saying.

[FDibbins]

Hi and welcome to the forum

You need to use absoluting on your ranges so they dont change when copying/sorting etc...
=INDEX('Computer grades'!$E$2:$E$20,MATCH('Student Information'!$B2,'Computer grades'!$A$2:$A$20,0))

[martindwilson]

this formula is wrong any way it only works because both sheets are the same layout
=INDEX('Computer grades'!E2:E20,MATCH('Student Information'!B2:B20,'Computer grades'!A2:A20,0))
change it to what fdibbins has put

[Khoori7]

Hi and welcome to the forum

You need to use absoluting on your ranges so they dont change when copying/sorting etc...
=INDEX('Computer grades'!$E$2:$E$20,MATCH('Student Information'!$B2,'Computer grades'!$A$2:$A$20,0))

Hey thanks that actually worked and thanks for your welcome!
I have another question if you don't mind me asking.
This is my search box..
http://i.imgur.com/RmoeChO.png
When i enter a correct result but if i enter an invalid student
http://i.imgur.com/ctfcTLD.png
It shows N/A can i make it say "Information not found"

this formula is wrong any way it only works because both sheets are the same layout
=INDEX('Computer grades'!E2:E20,MATCH('Student Information'!B2:B20,'Computer grades'!A2:A20,0))
change it to what fdibbins has put

Oh thanks mate, I changed them all to the same thing, so basically the highlighted part was wrong by my part right?

[FDibbins]

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

[Khoori7]

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

Here you go it's in the search tab.

[FDibbins]

wrap the formula in IFERROR...
=IFERROR(INDEX('Student Information'!$A:$E,MATCH(Search!$B$2&"*",'Student Information'!B:B,0),2),"")

Do that for all of them

[Khoori7]

Thank you very much for your help.

[FDibbins]

You are most welcome