vlookup type matrix creating

Hello, I would like to create a vlookup (excel) type operation that searches matrix A in matrix B and creates matrix C. How could I do it please in the most easy way?

 A = [0 0 1 0.25;
      0 1 1 0.75]
 B = [0 0 1;
      0 1 1;
      0 1 1;
      0 0 1;]  
 C = [0 0 1 0.25;
      0 1 1 0.75;
      0 1 1 0.75;
      0 0 1 0.25;] 
  

Thank you for any ideas!

Answer 1

[Steven Lord]

Since this sounds like it might be a homework question, I'm only going to point you in the direction of a useful function: ismember (with the 'rows' option.)

Answer 2

[Rafael Schwarzenegger]

This might do:

BB = zeros(4,4);
for i=1:2
 temp = [A(i,1:end-1)==B]; temp = logical(prod(temp,2));
 BB(temp,:) = repmat(A(i,:),sum(temp),1);
end

[Stephen23]

The MATLAB way:

>> [~,X] = ismember(B,A(:,1:3),'rows');
>> C = A(X,:)
C =
   0.00000   0.00000   1.00000   0.25000
   0.00000   1.00000   1.00000   0.75000
   0.00000   1.00000   1.00000   0.75000
   0.00000   0.00000   1.00000   0.25000