Sorting after using VLOOKUP

[Martha W. Stone]

I finally figured out the VLOOKUP function and have the info I need on one
spreadsheet. Now, I want to sort the spreadsheet. I think I need to "lock"
the formulas in the cells some way so they will sort with the correct
records. Is this even possible?

 

[Dave Peterson]

Do your =vlookup()'s refer to cells in the same row? If yes, then I bet you'll
be ok.

(If they used a different row, you might have trouble, though.)

The easiest check is to save your workbook, then apply the sort (to the whole
range). Then see if it worked for you.

If it didn't, you can close without saving (or just Edit|Undo).



One way to "lock" formulas is to get rid of them! Convert the formulas to
values. And the easiest way to do that is to select your range,
rightclick|Copy, then rightclick|Paste Special|Values.