Obtain all table elements from a column which correspond to certain string in another column

Hello,

I have a table with two columns. The first is a column of strings & the second numbers. I want to obtain all the elements in column 2 that correspond to the string 'Bonus' in column 1.

How can I do this?

Thank you

Answer 1

[Voss]

% a table
str = {'Onus';'Bonus';'Loan us';'On us';'Bonus';'Money';'Bonus'};
num = [1;2;3;2;4;3;1];
t = table(str,num)

t = 7×2 table
        str        num
    ___________    ___

    {'Onus'   }     1 
    {'Bonus'  }     2 
    {'Loan us'}     3 
    {'On us'  }     2 
    {'Bonus'  }     4 
    {'Money'  }     3 
    {'Bonus'  }     1 

% get the numbers corresponding to 'Bonus'
bonus_nums = t{strcmp(t{:,1},'Bonus'),2}

bonus_nums = 3×1

2 4 1

[Davindra Usov]

worked a charm. Thank you.