Is the VLOOKUP not working or are you trying to paste the
results somewhere else. If the later use Copy, paste special values

Otherwise, you will need to explain what you have and what is happening.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Sylgeox" wrote in message ...
I want to sort a column of character variables which have been computed by a
formula. The formula is VLOOKUP(....._). The standard sort routine does not
work because each cell contains the fomula used to arrive at the variable
rather than the variable itself. Is there a way I can copy the column and
retain the actual entries rather than the formula?