sorting in excel

[aceizace]

On excel i have a spreadsheet, and one of the columns contains a VLOOKUP of one of the others. When i try and sort the table by anything other than alphabetical (ie first name) the VLOOKUPS go out of place. For instance the one that was relitave to O10 does not move alongside the value in O10.

[davidprout]

You need to give a little more detail to get a proper answer. Are the columns adjacent to each other, How are you defining the sort range, give a couple of examples of the contents of the cell and what is happening etc. If you wish you can send me a copy of the spreadsheet and I will try to work out the problem for you. Please contact me before sending. [Email address removed as per site policy. - AB Editor]