=if formula resistant to Sort a to z

Hello Guys,

hope you can help. I have two sheets. And the main formula looks like this: =if(f67=1;F63)
Now I have around 300 rows of data. I need to sort it From a-z or z-a from time to time. But when I sort I`ll mix up my data on the second sheet.
Makes sense because F67 cell might me at C37 or C607 at some point. Now the question is: How to make the cells resistant to the sorting?
Or is it possible to lock up the coordinates of the cell, meaning: where ever it gets sorted it`ll have the exact same coordinate.

thanks in advance.

Not clear without seeing your sample workbook, try to upload at the forum, cjust click "Go Advanced" button and find Paperclip Button to attach your sample file

Thanks

ok there you go.

it gives out err501 can`t find the mistake.

Ok, found it and its brilliant thank you sktneer.

Ok, the problem still ain`t solved. Is it possible to give constant coordinates to the cells? so after sorting they would stay the same lets say a50 will locate at the coordinates a87 but somehow it would still say a50?