Sorting cells fed by formulas

Hey there.
I am trying to sort a column which is fed by a formula, and every time I try, the formula sets the number back to what it is feeding to it, thus not sorting it.
Is there a way I can sort the column?

Pure hypothetically, try locking the formula by using the $ sign.

using the $ sign appears to have worked from what I can tell.
I want however for it to sort across two columns, column A is a number 1-3 and column B is another number. When I hit sort though they sort each column individually. How can i keep the two columns grouped as such, so that the for example, original A1 will stay with the original B1, rather then ending up next to B12.

Sorry, I am not all that learned with excel.

thats what I thought it was supposed to do, which is why I am confused.
No I am not getting any pop up message when I sort it.