keep the same row data from two matrix

i have a total data matrix a(253*2), now i just want to keep the data from b(223*1) and get the whole data is c(223*2), which means that keep the same data between a&b. how should i do?

[Mathieu NOE]

hello

you mean c would be the first 223 rows of a ?

then this is it :

c = a(1:223,:);

[zhengyang shang]

of course not, first need to find the data in the first row in the b and also in the first row in a, then output the c

[Mathieu NOE]

OK so you have to use find the get the similar values from col 1 in a and b

ind = find(a(:,1) == b);
c = a(ind,:);

Answer 1

[Jan]

This is a job for intersect or ismember.

[~, ia, ib] = intersect(a(:, 1), b);
c = [b(ib), a(ia, 2)]

[zhengyang shang]

actually it still doesn't work because it tell me a and b are not contain same variable. i upload the data the matrix a is on the sheet1 and matrix b is on the sheet2.

Thanks so much!

[Jan]

I cannot follow you. The tables do share at least some common data. So my code is expected to work. If it does not work for you, please post your code.