Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare 2 columns and choose one and enter answer in third column
New here and so far you all are absolutely wonderful!! I have one
problem here that I can't seem to find a solution to.... 2 part problem: PART 1 Here's a sample of my data: Column E = Business Name Column F = Address 1 Column G = Address 2 Column H = Address 3 Column I = City Column J = State Column K = Zip Sample: E = WPI F = Dept Of Management G = 100 Institute Rd H = Suite 220 I = Worcester J = MA K = 01609-2247 As you can see from WPI 'Dept of Management' is in my Address 1 Column. This is where a major part of my problem lies. Is there a way to create a new column in between H and I and somehow get it to compare F & G & H and extract the street address into the new column? PART 2 Once I have this new column I then need to be able to take the Business Name and the new address column and compare it to the NEW Business Name and Address column and return a specified numerical response into another column if there is a match. Is this at all possible? Here's the catch....can I compare the Business names based on just the first few letters in each column? Ie. I will be comparing 'Ann Taylor' to 'Anntaylor Inc.'. Thank you! and hope I didn't give you too much of a headache. Beth |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare 2 columns and choose one and enter answer in third column
Betsy wrote: I have one problem here that I can't seem to find a solution to.... 2 part problem: PART 1 Here's a sample of my data: Column E = Business Name Column F = Address 1 Column G = Address 2 Column H = Address 3 Column I = City Column J = State Column K = Zip Sample: E = WPI F = Dept Of Management G = 100 Institute Rd H = Suite 220 I = Worcester J = MA K = 01609-2247 As you can see from WPI 'Dept of Management' is in my Address 1 Column. This is where a major part of my problem lies. Is there a way to create a new column in between H and I and somehow get it to compare F & G & H and extract the street address into the new column? PART 2 Once I have this new column I then need to be able to take the Business Name and the new address column and compare it to the NEW Business Name and Address column and return a specified numerical response into another column if there is a match. Is this at all possible? Here's the catch....can I compare the Business names based on just the first few letters in each column? Ie. I will be comparing 'Ann Taylor' to 'Anntaylor Inc.'. Thank you! and hope I didn't give you too much of a headache. Beth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Retreive data from another worksheet based on multiple columns | Excel Discussion (Misc queries) | |||
A parent spreedsheet problem | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |