Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup won't work on these two particular spreadsheets
I have done many Vlookups, but these two spreadsheets have come to me from
unidentified sources. I copied onto new workbooks, I cocatinated, and nothing is working - now even sort is failing ?? any help would be appreciated. mk |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup won't work on these two particular spreadsheets
Any number of issues could be the cause.
Extra spaces or non-breaking spaces in text cells. Hidden characters in text cells. Numbers are text that look like numbers. Number formatting could be concealing extra decimals. What and why did you Concatinate(sic)? Gord Dibben MS Excel MVP On Wed, 24 Dec 2008 09:07:01 -0800, mk wrote: I have done many Vlookups, but these two spreadsheets have come to me from unidentified sources. I copied onto new workbooks, I cocatinated, and nothing is working - now even sort is failing ?? any help would be appreciated. mk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing two spreadsheets using vlookup and compare | Excel Worksheet Functions | |||
Copying spreadsheets-did not work | Excel Discussion (Misc queries) | |||
How can I link excel spreadsheets that work on other computers | Excel Discussion (Misc queries) | |||
Linking between spreadsheets does not work unless I have both spr. | Excel Discussion (Misc queries) | |||
using vlookup - how do I match 2 spreadsheets w/o same exact numb. | Excel Worksheet Functions |