How to index into a table with more than 1 variable?

Hi,

The current problem i have is trying to index into a table using more than 1 variable. I want to be able to show all rows that have "mark" and "paul" in the name column. Here is an example of what i am trying to do:

table = 20x4 (various data here col 4 = to table.name)

a = {'mark', 'paul'};

idx = table(strcmp(table.name, a), :);

I just receieve and errors that says - "Row index exceeds table dimensions."

This method works if i only use one name in the a paramater. Not sure why it wont for more than one.

Answer 1

[Stephen23]

Where T is your table (do NOT use table as a variable name):

out = T(ismember(T.name,a),:);

[MKM]

cheers, Stephen. Why does this work and the function i used not?