Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing Values in a Spreadsheet
I'm fairly sure that this is just a LOOKUP function, but I cannot understand
the Excel help file on VLOOKUP. I have about 14,000 records in Column A. Columns B through F each contain verbal descriptors about the information in A. If you combine B through F in every possible way, there are 274 possible combinations. Obviously it's mathematically possible to have many more than 274, but there are 274 discreet combinations that occur for this particular set of descriptors. Meanwhile, each descriptor has been assigned a code that a data extraction program will use. I want to use an Excel function that will see the TEXT term, find the CODE that goes with that TEXT and replace the TEXT with the CODE - on a column-by-column basis. Example of TEXT: Alabama Shoes Formal Black Patent Texas Suits Men's Blue Pinstripe Associated CODE: Alabama 0A1 Shoes 1A2 Formal 9B3 Black 3A6 Patent 4L7 Texas 0B9 Suits 1Z4 Men's L4Z Blue 9C1 Pinstripe 44Z Each verbal descriptor has been assigned a unique CODE; all 274 descriptors. Can someone explain the syntax to be used in telling Excel to look for the descriptor Alabama and if it "sees" Alabama, to substitue the corresponding 3-digit CODE? If this is a VLOOKUP, does Excel over-write Alabama or is the new table being built on another worksheet? If you don't have the time or desire to teach basic LOOKUP, I understand. If that turns out to be the case, could you refer me to an Excel help website that would break out the procedure into its most basic steps? Many thanks.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing Values in a Spreadsheet | Excel Discussion (Misc queries) | |||
Replacing Linked Cell Values w/ Current Values | Excel Worksheet Functions | |||
AFTER REPLACING FORMULA WITH VALUES, HOW DO I ADD THE COLUMN? | Excel Discussion (Misc queries) | |||
Replacing missing values? | Excel Worksheet Functions | |||
Replacing zero values with dashes | Excel Discussion (Misc queries) |