Rearranging second matrix based on the order of first matrix

I have two matrices A and B with n number of rows and 4 columns. The 2nd and third column of both matrices are same but not the order. I would like to arrange the matrix B with respect to the order of 2nd and third column in matrix A.

A = [ 1 2 3 4.1; 5 12 7 4.1; 9 10 11 4.1];

B = [ 131 10 11 8.1; 21 12 7 8.1; 91 2 3 8.1];

so B sorted should look like,

Bsorted = [91 2 3 8.1; 21 12 7 8.1; 131 10 11 8.1]

Thanks

Answer 1

[Stephan]

A = [1 2 3 4.1; 5 12 7 4.1; 9 10 11 4.1]
B = [131 10 11 8.1; 21 12 7 8.1; 91 2 3 8.1];

B_new = sortCols2_3(A,B)

function B_new = sortCols2_3(A,B)
[m,n]=meshgrid(1:size(A,1),1:size(A,1));
B1 = reshape(B(m,2:3)==A(n,2:3),size(A,1),[]);
B1 = B1(:,1:size(A,1));
[r,c] = find(B1);
B_new(c,:)=B(r,:);
end

[Yasir Zahoor]

@Stephan thank you for the response. My apologise for probably not explaining enough. The second and third columns are actually x and y coordinates and their order in column A is completely random (unlike in the example where columns 3 in A is in ascending order). Hence it is important to relate to A while rerordering B (keeping it as generic as possible). I have tried different things using indexing but being a novice, nothing worked.

[Stephan]

see my edited answer.

i tried it also with this extended example, it appears to work for me:

A = [1 2 3 4.1; 5 12 7 4.1; 9 10 11 4.1; 11 6 8 21]
B = [1 6 8 1; 131 10 11 8.1; 21 12 7 8.1; 91 2 3 8.1];

[Yasir Zahoor]

Thanks alot. It works.