HelloEveryone,<o></o>
<o></o>
Need some help on something I've been working on and can’t seem to find a solution:<o></o>
I'mtrying to extract owner name and address data for about 200 names from a sourcespreadsheet of ~200,000 names and addresses, imported from a comma-delimited dbffile. The source data has a single text field consisting of lastname, firstname, "+", spouse name, etc.; the spouse name may, or may not, existin the table, and may have trailing characters following it. With a list of 200,000,there will obviously be multiple matches on each name, but very few dupes ofBOTH first and last together on one row; I can sort that out manually. If I canget a match on the first and last name strings, I can sort out the addressinfo. All fields are formatted as text.<o></o>
<o></o>
I'vecopied the 200 target name list to the right of the source data list so tablestructure is as follows:<o></o>
<o></o>
Sourcedata__________________________List toMatch<o></o>
SourceName field, address, city, state, zip, OwnerLast Name, Owner First Name<o></o>
SmithBob + Janet Tr, 125 Oak lane, Atlanta, GA, 55555, Smith, Bob, Janet,<o></o>
<o></o>
Thecrux of the problem is that the Owner First Name above could be either "Bob"or "Janet" in the above example. So what I'm trying to get is: <o></o>
If SourceName Field contains both Owner Last Name and Owner First Name in the samestring, give the (source) address info to the right of Source Name Field.<o></o>
<o></o>
Ihave tried various combinations with VLookups, Index/Match, etc., (with helpercolumns and wildcards) without success. Anyhelp would be GREATLY appreciated!<o></o>
TIA <o></o>
<o></o>
Need some help on something I've been working on and can’t seem to find a solution:<o></o>
I'mtrying to extract owner name and address data for about 200 names from a sourcespreadsheet of ~200,000 names and addresses, imported from a comma-delimited dbffile. The source data has a single text field consisting of lastname, firstname, "+", spouse name, etc.; the spouse name may, or may not, existin the table, and may have trailing characters following it. With a list of 200,000,there will obviously be multiple matches on each name, but very few dupes ofBOTH first and last together on one row; I can sort that out manually. If I canget a match on the first and last name strings, I can sort out the addressinfo. All fields are formatted as text.<o></o>
<o></o>
I'vecopied the 200 target name list to the right of the source data list so tablestructure is as follows:<o></o>
<o></o>
Sourcedata__________________________List toMatch<o></o>
SourceName field, address, city, state, zip, OwnerLast Name, Owner First Name<o></o>
SmithBob + Janet Tr, 125 Oak lane, Atlanta, GA, 55555, Smith, Bob, Janet,<o></o>
<o></o>
Thecrux of the problem is that the Owner First Name above could be either "Bob"or "Janet" in the above example. So what I'm trying to get is: <o></o>
If SourceName Field contains both Owner Last Name and Owner First Name in the samestring, give the (source) address info to the right of Source Name Field.<o></o>
<o></o>
Ihave tried various combinations with VLookups, Index/Match, etc., (with helpercolumns and wildcards) without success. Anyhelp would be GREATLY appreciated!<o></o>
TIA <o></o>