Matching elements in a matrix with elements in another matrix
    8 views (last 30 days)
  
       Show older comments
    
I have a matrix, 
A=[1 3 4 
   3 1 5 
 NaN 3 6]
and another index matrix
B=[1 333
    2 356
    3 112
    4 789
    5 762
    6 221
    7 876
    8 922]
I want to match the elements in matrix A with the correesponding index (1st column) in matrix B and return
C=[333 112 789
    112 333 762
    NaN 112 221]
 I tried using ismember, (by first making matrix A to a vector), however it did not work
0 Comments
Accepted Answer
  Stephen23
      
      
 on 5 Feb 2020
        >> [idx,idy] = ismember(A,B(:,1));
>> C = nan(size(A));
>> C(idx) = B(idy(idx),2)
C =
   333   112   789
   112   333   762
   NaN   112   221
More Answers (0)
See Also
Categories
				Find more on Creating and Concatenating Matrices in Help Center and File Exchange
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
