MATLAB: Indexing with two matrices

indexingmatrices

I have two matrices A(1000 by 100) and B(10 by 100).
A=
1 4 20
3 5 15
2 1 24
7 9 42
B=
3 4 15
7 1 42
I want to return a matrix C such that, for each column of B i find the indexes in the coresponding column in A.
For this case:
C=
2 1 2
4 3 4
I have tried the code below, but i am not getting what I want.
for i=1:size(A,2)
    C(:,i)=intersect(A(i),B(i));
end

Best Answer

A=[1    4    20
   3    5    15
   2    1    24
   7    9    42];
B=[3    4    15
   7    1    42];
[r1,c1]=size(B);
c=zeros(r1,c1);
for i=1:r1
for j=1:c1
   r=find(B(i,j)==A(:,j))
   c(i,j)=r
end 
end
c
#
c =
     2     1     2
     4     3     4
Related Question