| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookups not sorting correctly
I have a workbook that has a couple sheets in it. Due to all the little
hands that like to play we have data integrity issues. To solve this problem I created the second sheet. In this sheet there are columns for reference and columns for users to do there data entry.I have vlookups going in both directions (to and from each sheet) based on a unique number. The problem we have is in this update sheet. When a user tries to short the sheet its really not sorted. It actaully mixes up some of the data. My question is what is the vlookup returning that excel sorts funny? Please help John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookups not sorting correctly
You can't sort a column full of Vlookup results, well you can but it doesn't
work, you would have to copy and paste special values prior to sorting -- -- -John Please rate when your question is answered to help us and others know what is helpful. "runsrealfast" wrote in message ups.com... I have a workbook that has a couple sheets in it. Due to all the little hands that like to play we have data integrity issues. To solve this problem I created the second sheet. In this sheet there are columns for reference and columns for users to do there data entry.I have vlookups going in both directions (to and from each sheet) based on a unique number. The problem we have is in this update sheet. When a user tries to short the sheet its really not sorted. It actaully mixes up some of the data. My question is what is the vlookup returning that excel sorts funny? Please help John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting numbers doesn't work correctly | New Users to Excel | |||
| Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
| Pivot Table not sorting correctly | Charts and Charting in Excel | |||
| Letters and 000s in front of actual number not sorting correctly | Excel Discussion (Misc queries) | |||
| sorting number in ascending order | Excel Discussion (Misc queries) | |||
Linear Mode
