I can't state my problem very well, which may be why I can't solve it!
I have a spreadsheet with two tabs.
The sheet on one tab has about 6k rows.
The other tab has about 3k.
The larger sheet has addresses (col.C) associated to names (col. B).
The smaller sheet has a list of names that is essentially correct (Col.B). There are some nicknames, and half are Last,First (Smith, John) and the other half are First Last (John Smith).
I need to put addresses on the smaller sheet by querying the larger for name in column B (this will be "contains part of the string") and return a name-to-address association column on the smaller sheet.
The two sheet rows do not match in order or in content. It needs to be a row-by-row iterative query then return to the new adjacent and related column on the smaller sheet.
What tools do I use?
Are there any scripting sites that can help?
Somehow I cannot image that I'm the first person to need to do this...
All thoughts, ideas, help, and sympathy appreciated!
Thank you
I have a spreadsheet with two tabs.
The sheet on one tab has about 6k rows.
The other tab has about 3k.
The larger sheet has addresses (col.C) associated to names (col. B).
The smaller sheet has a list of names that is essentially correct (Col.B). There are some nicknames, and half are Last,First (Smith, John) and the other half are First Last (John Smith).
I need to put addresses on the smaller sheet by querying the larger for name in column B (this will be "contains part of the string") and return a name-to-address association column on the smaller sheet.
The two sheet rows do not match in order or in content. It needs to be a row-by-row iterative query then return to the new adjacent and related column on the smaller sheet.
What tools do I use?
Are there any scripting sites that can help?
Somehow I cannot image that I'm the first person to need to do this...
All thoughts, ideas, help, and sympathy appreciated!
Thank you