Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help ... comparing text
I have an Excel spreadsheet that has 2 columns so far ...
Col A = suburb name in full Col B = an abbreviated version of the suburb (this appears on the same row as the full name that appears in Col A) I now need to enter hundreds of abbreviated suburb names - multiple and in no particular order (which will be entered into a new column - Col C) Question: is there a way I can "ask" ... if Col C matches any in Col B (not case-sensitive preferably), then insert Col A (full suburb) into a 4th (new) column (Col D)? I apologise, I know this is a little confusing, but I would appreciate any advice/help - I have searched everywhere and can't seem to find an answer. -- Sally M, Queensland, Australia |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help ... comparing text
One way ..
Assuming data starts in row2 down Put in D2: =IF(ISNA(MATCH(C2,B:B,0)),"",INDEX(A:A,MATCH(C2,B: B,0))) Copy down as far as required. If there's no match found for the lookup values in col C, blanks: "" will be returned. MATCH is not case sensitive, as desired. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Sally M." wrote: I have an Excel spreadsheet that has 2 columns so far ... Col A = suburb name in full Col B = an abbreviated version of the suburb (this appears on the same row as the full name that appears in Col A) I now need to enter hundreds of abbreviated suburb names - multiple and in no particular order (which will be entered into a new column - Col C) Question: is there a way I can "ask" ... if Col C matches any in Col B (not case-sensitive preferably), then insert Col A (full suburb) into a 4th (new) column (Col D)? I apologise, I know this is a little confusing, but I would appreciate any advice/help - I have searched everywhere and can't seem to find an answer. -- Sally M, Queensland, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing cells with text | Excel Worksheet Functions | |||
comparing text cells | Excel Worksheet Functions | |||
Comparing Two Columns of Text | Excel Discussion (Misc queries) | |||
Comparing text in columns | Excel Discussion (Misc queries) | |||
Comparing text fields | Excel Worksheet Functions |