MATLAB: Create new variable if elements of different variables match in Matlab

cell arraysconditionmatch

I have 3 cell arrays: A that has 3 columns and 5000 rows. B that has 5 and 60 columns. C that has 4 columns and 500 rows. Sample of each varaible:
A= { 12  1999  41.2
     13  1999  47.7
     16  1999  52.7}
B= { 16  452  8  407  31
   1037  110  14  873  93
   1255  881  20  16  69}
C= { 13  1997  1999  2000
    141  1997  1999  2000
    174  1997  1999  2000}
If a value of the 1st column of A matches any value of the 1st column of B , I would like to add to A, columns 1, 4 and 5 of B plus a column only with the value 'one' . In case a value of the 1st column of A matches a value of the 1st column of C, I would like to add to A, columns 1 and 4 of C and an extra column with zeroes.
So the output would be:
Output= { 12  1999  41.2
          13  1999  47.7  13 2000 0    %match between A & C 
          16  1999  52.7  16 407 31 1} %match between A & B
Can someone help me? Thank you.

Best Answer

EDIT
a1=[A{:,1}];
b1=[B{:,1}];
c1=[C{:,1}];
n=numel(a1);
out=cell(n,7);
out(:,1:3)=A;
ii=[ismember(a1,b1)'  ismember(a1,c1)'];
for k=1:numel(a1)
  if ii(k,1)==1;
      ib=find(b1==a1(k),1)
      out(k,4:7)=[B(ib,[1 4 5]) {1}];
  elseif ii(k,2)==1
      ic=find(c1==a1(k),1);
      out(k,4:6)=[C(ic,[1 4]) {0} ];
  end
end
out
Related Question