Hello Forum members, I hope you might be able to help.
Two sets of lists were collected at different times. In one list there is 800 hundred data sets with one column named "Title" which has text in it. In the other list collected later an extra column of data was collected with a column named "Name" and also a column named "Title". The two columns named "Title" have similar data in them, but sometimes the second data set has more data in it - perhaps as much as 1300 data sets, instead of 800. Typos in the second data set, mean that some of the data is not the same as the original data set named "Title" in data set one, and also there is some extra data. There is about ten percent error in data set two. I am happy to match this error-ed data by eye. It was realised after data set one was collected that the named column "Title" did not identify an individual quick enough to be of use. The second data set had the required information in it and was used to pre-populate data set one in the first place. I now need to match the two data sets to identify the "Title" of data set one with the "Name" of data set two. Sorting and filtering the data sets is not practical as there is differing formula derived information between the data sets elsewhere in the spreadsheets, which are not referenced correctly. Sorting the data sets throws enumerable #REF errors.
Against the named column "Title" in data set two there is the named column "Name". I require to match the column named "Title" in data set one with the correct matched name from the column named "Name" from data set two. If possible when I have a "Title" match in the two data sets, I would like to be able to copy the "Name" column matched data automatically to Data Set three. I know this a clumsy way of explaining this and if the question is too n00bish to be worth answering, I would be grateful if an experienced forum member could post and say so and I will quietly delete it for you. Thank you for reading so far, I appreciate it.
ps - I inherited the lists and the issues, and did not contribute to the design of the spreadsheet - he said apologetically
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Data Set One[/TD]
[TD][/TD]
[TD]Data Set Two[/TD]
[TD][/TD]
[TD][/TD]
[TD]Desired Data Set three[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Title[/TD]
[TD][/TD]
[TD]Title[/TD]
[TD]Name[/TD]
[TD][/TD]
[TD]Title[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Programme Manager[/TD]
[TD][/TD]
[TD]Project Manan
ager[/TD]
[TD]Derf Noone[/TD]
[TD][/TD]
[TD]Project Manager[/TD]
[TD]Derf Noone[/TD]
[/TR]
[TR]
[TD]Project Manager[/TD]
[TD][/TD]
[TD]Program Manager[/TD]
[TD]Fred Twojobs[/TD]
[TD][/TD]
[TD]Programme Manager[/TD]
[TD]Fred Twojobs[/TD]
[/TR]
</tbody>[/TABLE]
Two sets of lists were collected at different times. In one list there is 800 hundred data sets with one column named "Title" which has text in it. In the other list collected later an extra column of data was collected with a column named "Name" and also a column named "Title". The two columns named "Title" have similar data in them, but sometimes the second data set has more data in it - perhaps as much as 1300 data sets, instead of 800. Typos in the second data set, mean that some of the data is not the same as the original data set named "Title" in data set one, and also there is some extra data. There is about ten percent error in data set two. I am happy to match this error-ed data by eye. It was realised after data set one was collected that the named column "Title" did not identify an individual quick enough to be of use. The second data set had the required information in it and was used to pre-populate data set one in the first place. I now need to match the two data sets to identify the "Title" of data set one with the "Name" of data set two. Sorting and filtering the data sets is not practical as there is differing formula derived information between the data sets elsewhere in the spreadsheets, which are not referenced correctly. Sorting the data sets throws enumerable #REF errors.
Against the named column "Title" in data set two there is the named column "Name". I require to match the column named "Title" in data set one with the correct matched name from the column named "Name" from data set two. If possible when I have a "Title" match in the two data sets, I would like to be able to copy the "Name" column matched data automatically to Data Set three. I know this a clumsy way of explaining this and if the question is too n00bish to be worth answering, I would be grateful if an experienced forum member could post and say so and I will quietly delete it for you. Thank you for reading so far, I appreciate it.
ps - I inherited the lists and the issues, and did not contribute to the design of the spreadsheet - he said apologetically
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Data Set One[/TD]
[TD][/TD]
[TD]Data Set Two[/TD]
[TD][/TD]
[TD][/TD]
[TD]Desired Data Set three[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Title[/TD]
[TD][/TD]
[TD]Title[/TD]
[TD]Name[/TD]
[TD][/TD]
[TD]Title[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Programme Manager[/TD]
[TD][/TD]
[TD]Project Manan
ager[/TD]
[TD]Derf Noone[/TD]
[TD][/TD]
[TD]Project Manager[/TD]
[TD]Derf Noone[/TD]
[/TR]
[TR]
[TD]Project Manager[/TD]
[TD][/TD]
[TD]Program Manager[/TD]
[TD]Fred Twojobs[/TD]
[TD][/TD]
[TD]Programme Manager[/TD]
[TD]Fred Twojobs[/TD]
[/TR]
</tbody>[/TABLE]
