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 |
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 |
All times are GMT +1. The time now is 11:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com