Question regarding a find function(search for data)

Hi, I have the following matrix:

data=[10 1 2 3; 11 4 5 6; 12 7 8 9; 17 4 5 6]

I want to do a query with the following matirx:

built a matrix base on the element value 10 and 17

lookfor=[10;17]

And I'm looking for the following result(values associate with 10 and 17 in this case)

anwser=[10 1 2 3; 17 4 5 6]

I'm looking for a dynamic anwser, data matrix and lookfor matrix will vary and be much more bigger.

thank you in advance for your precious anwsers.

Answer 1

[Azzi Abdelmalek]

out=[data(any(data==17,2),:);data(any(data==10,2),:)]

%or

out=data(any(ismember(data,lookfor),2),:)

[Gimpy]

is there a way to do a "group by" with this method?

let'S say the data is the following: data=[10 1 2 3; 11 4 5 6;10 0 20 30; 11 4 5 6; 12 7 8 9; 17 40 50 60]

lookfor=[10;17]

And I want the following anwser:

anwser=[10 1 22 33; 11 8 10 12]

thank you

[Gimpy]

using: out=data(any(ismember(data,lookfor),2),:)

[Azzi Abdelmalek]

How did you find anwser=[10 1 22 33; 11 8 10 12]

[the cyclist]

Looks like he wants to find rows that start with 10, and sum them into one row. Then find rows that start with 11, and sum them.

Answer 2

[the cyclist]

rowIndex = ismember(data(:,1),lookfor);
answer = data(rowIndex,:);