Formula changing with sort

[Dena]

I don't know what I am doing wrong. I have a formula that works and when I filter, it stays with the correct row but when I sort by the columns it moves around incorrectly and changes. How do I get the formula to stay the it's correct row.

13-14 budget.xlsm

Its the tab titled "Student Worker List". When I sort by any of the columns the formula in column J gets all out of whack. Any suggestions?

[martindwilson]

try
=IF(ISNA(INDEX('Student Budget Balances'!$E$2:$E$13,MATCH(INDEX('Student Worker List'!$D:D,ROW()),'Student Budget Balances'!$A$2:$A$13,0))),"",INDEX('Student Budget Balances'!$E$2:$E$13,MATCH(INDEX('Student Worker List'!$D:D,ROW()),'Student Budget Balances'!$A$2:$A$13,0)))
edit you have excel 2007 or later so you could use iferror insted
=IFERROR(INDEX('Student Budget Balances'!$E$2:$E$13,MATCH(INDEX('Student Worker List'!$D:D,ROW()),'Student Budget Balances'!$A$2:$A$13,0)),"")

[Dena]

Thank you, this worked like a charm.