View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Enhance Sort Results

Just point the vlookup to lookup C2:C21 instead of D2:D21. C2:C21 contains
the numbers in alignment.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"maperalia" wrote in message
...
Max'
Thanks very much.
I set up the function and the formulas in the way you advised me. It is
working perfectly.
However, when I want the result (D2:D21) to be read as number to vlookup
from another column just the number without text is read the rest not.
Can you help me please?

Thanks.
Maperalia