LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort by column problems OfficeNDN Excel Worksheet Functions 2 August 31st 06 08:53 AM
Excel "mode" function returns different results based on sort orde Mark Neuffer Excel Worksheet Functions 7 April 25th 06 08:15 AM
How to sort but keep linked formulas? GovUser Excel Discussion (Misc queries) 7 April 3rd 06 10:36 PM
How do I format a column in alpha order? Marian New Users to Excel 3 April 2nd 06 05:15 PM
Data > Sort function amnesia? Dave D Excel Discussion (Misc queries) 1 November 29th 04 10:44 PM


All times are GMT +1. The time now is 04:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"