If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell Word Alphabetization
I am working on doing a vlookup for values on another that may or may not be in a different order. Vlookup won't pick these words up, so I was wondering if anyone knew a solution or a way to alphabetize the words with each cell so that vlookup will work in all cases. Thanks in advance. -- tonerockyhorror ------------------------------------------------------------------------ tonerockyhorror's Profile: http://www.excelforum.com/member.php...o&userid=34136 View this thread: http://www.excelforum.com/showthread...hreadid=539056 |
#2
|
|||
|
|||
Cell Word Alphabetization
Can you post your formula here with a bit more description?
If you are using VLOOKUP with the fourth parameter set to TRUE or 1 or omitted, then the lookup data will have to be sorted and your result will be the value in the lookup table closest to (and less than if not an exact match) the search data. However, if this parameter is set to FALSE or 0, then you will be looking for exact matches and the data does not need to be in any particular order. Hope this helps. Pete |
#3
|
|||
|
|||
Cell Word Alphabetization
The fourth parameters is set false because I am cross-referencing data appearing in one sheet that doesn't appear in another. The problem is that some words will show up a few different times with different data attached in corresponding cells. Some of the words also appear in varying orders, but I need vLookup to include those as well. Setting the fourth parameter to true or false or grab that data. I was told that there is a way to alphabetize the data within a cell though. With that I could get the data I need but I have no idea what function in excel can do this. I know this is all a little vague, but thats because the work I do in excel is not number-based and a little tricky to understand. -- tonerockyhorror ------------------------------------------------------------------------ tonerockyhorror's Profile: http://www.excelforum.com/member.php...o&userid=34136 View this thread: http://www.excelforum.com/showthread...hreadid=539056 |
#4
|
|||
|
|||
Cell Word Alphabetization
Yes, it is still very vague - how can you expect people to help?
I repeat: Can you post your formula here with a bit more description? Pete |
#5
|
|||
|
|||
Cell Word Alphabetization
Well the help I expected was more in the form of can I alpabetize words within a cell? (Yes/No) I can solve my own problem with that. Otherwise just forget everything else I said because I can't explain in any more detail about my setup. Right now I am just using a standard vlookup. ie. =vlookup(cell value,column range,x,false) -- tonerockyhorror ------------------------------------------------------------------------ tonerockyhorror's Profile: http://www.excelforum.com/member.php...o&userid=34136 View this thread: http://www.excelforum.com/showthread...hreadid=539056 |
#6
|
|||
|
|||
Cell Word Alphabetization
I don't understand your term "alphabetize". Can you explain what you
mean by this with reference to some simple words? For example, if the words you had were dog, horse, monkey, what would you expect to happen if these were "alphabetized"? Trying to help... Pete |
#7
|
|||
|
|||
Cell Word Alphabetization
Pete
I interpret this to mean "sort" words in a cell. dog, horse, monkey would be ascending. monkey, horse, dog would be descending. I am sure someone out there has written a UDF for this. Gord Dibben MS Excel MVP On 5 May 2006 16:09:59 -0700, "Pete_UK" wrote: I don't understand your term "alphabetize". Can you explain what you mean by this with reference to some simple words? For example, if the words you had were dog, horse, monkey, what would you expect to happen if these were "alphabetized"? Trying to help... Pete |
#8
|
|||
|
|||
Cell Word Alphabetization
Thanks, Gord, that's what I thought it meant, though I'm not sure how
this relates to the OP's problem - I think he has multiple entries in his lookup table and will always find the first exact match and he doesn't want this, but he is reluctant to give any further details so I'm not sure how we can help him. Pete |
#9
|
|||
|
|||
Cell Word Alphabetization
We can wait for OP to follow up, is all.
Gord On 5 May 2006 17:31:39 -0700, "Pete_UK" wrote: Thanks, Gord, that's what I thought it meant, though I'm not sure how this relates to the OP's problem - I think he has multiple entries in his lookup table and will always find the first exact match and he doesn't want this, but he is reluctant to give any further details so I'm not sure how we can help him. Pete Gord Dibben MS Excel MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting Word Perfect forms to Word forms | Charles Kenyon | General Discussion | 0 | February 15th, 2006 08:17 PM |
WP merge file to Word | sstires | Tables | 4 | February 14th, 2006 06:26 PM |
Word 97 in Windows XP to maintain formatting | Charlie''s Word VBA questions | General Discussion | 21 | October 24th, 2005 09:49 PM |
How to change merge forms from Word Perfect to Microsoft Word | Charles Kenyon | General Discussion | 1 | December 30th, 2004 03:35 PM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |