Matching string, and update the table

Hi,

I want the "Final resulting table". I have Country and names, and NameDataList (names and data). I want add country names to "NameDataList" so as I want to get 'Final resulting table'. Can someone kindly help me how to get Final resulting table from the other two tables. Many many thanks in advance.

I used the following code:

clc;
clear all;
close all;
[num ,txt,CNL]=xlsread('CountyNameList.xlsx');
[num2,txt2,NDL]=xlsread('NameDataList.xlsx');

X = cellfun(@(c)find(strcmp(c,CNL(:,2))),NDL(:,1));
out = [CNL(X,1),NDL];

But it gives error:

??? Error using ==> cellfun Non-scalar in Uniform output, at index 7, output 1. Set 'UniformOutput' to false.

Error in ==> Matchingrearrangingdata at 7 X = cellfun(@(c)find(strcmp(c,CNL(:,2))),NDL(:,1));

Please someone help me,

CountyNameList:

      Country1    Name1
      Country1    Name3
      Country1    Name6
      Country1    Name7
      Country2    Name9
      Country2    Name12
      Country2    Name14
      Country3    Name18
      Country3    Name19
      Country3    Name21
      Country4    Name25
      Country4    Name31
      Country4    Name40

NameDataList:

Name1   0.1
Name6   0.3
Name1   0.2
Name3   0.3
Name3   0.4
Name6   0.3
Name1   0.2
Name1   0.5
Name6   0.4
Name7   0.2
Name3   0.3
Name1   0.6
Name9   0.5
Name9   0.4
Name12  0.1
Name12  0.3
Name14  0.4
Name14  0.4
Name14  0.4
Name18  0.5
Name18  0.4
Name18  0.6  
Name14  0.4
Name18  0.5
Name19  0.4
Name19  0.6 
Name14  0.4
Name19  0.5
Name19  0.4
Name1   0.6 
Name21  0.4
Name21  0.5
Name31  0.4
Name40  0.6 
Name14  0.4
Name21  0.5
Name31  0.4
Name25  0.6 
Name14  0.4
Name40  0.5
Name31  0.4
Name25  0.6 
Final resulting table I want:

Country1  Name1   0.1
Country1  Name6   0.3
Country1  Name1   0.2
Country1  Name3   0.3
Country1  Name3   0.4
Country1  Name6   0.3
Country1  Name1   0.2
Country1  Name1   0.5
Country1  Name6   0.4
Country1  Name7   0.2
Country1  Name3   0.3
Country1  Name1   0.6
Country2  Name9   0.5
Country2  Name9   0.4
Country2  Name12  0.1
Country2  Name12  0.3
Country2  Name14  0.4
Country2  Name14  0.4
Country2  Name14  0.4
Country3  Name18  0.5
Country3  Name18  0.4
Country3  Name18  0.6
Country2  Name14  0.4
Country3  Name18  0.5
Country3  Name19  0.4
Country3  Name19  0.6
Country2  Name14  0.4
Country3  Name19  0.5
Country3  Name19  0.4
Country1  Name1   0.6
Country3  Name21  0.4
Country3  Name21  0.5
Country4  Name31  0.4
Country4  Name40  0.6
Country2  Name14  0.4
Country3  Name21  0.5
Country4  Name31  0.4
Country4  Name25  0.6
Country2  Name14  0.4
Country4  Name40  0.5
Country4  Name31  0.4
Country4  Name25  0.6

[Michael Haderlein]

Please do not ask the same question multiple times:

http://de.mathworks.com/matlabcentral/answers/179100-how-to-find-matching-string-and-re-arrange-the-table

[per isakson]

You can do this with a for-loop!