From: nooknickgigga korbenjawan on
I have a question alike to 'sumif' in excel formula but want to have a little bit command more than that which is :

a=[’kitty’ 1;’car’ 2;’yoka’ 10]
b=[‘kitty’ ‘happy’;’dog’ ‘sad’;’car’ ’broken’]
c=[127 12; 130 32;164 81]
z=[‘yoka’ ‘tried’]
d=[11 15;13 25; 100 200]
%if a (first column) is matched any b(first column), I want it create any file which pull data from ( c ) as :
Ans =[kitty happy 12;car broken 81]
%if a(first column) doesn’t match any of b(first column), then search from another file (d) as :
Ans=[yoka tired 15]

Anyone can help for matlab code?
Thanks
From: dpb on
nooknickgigga korbenjawan wrote:
> I have a question alike to 'sumif' in excel formula but want to have a
> little bit command more than that which is :
>
....

doc ismember % and friends

--