How to print information based on ids in another column?

I have a list of ids in one column and color in the 2nd column. how do i print information based on the id. if you scan through the entire id and if apple is a match it should print out red in the column next to it. The final output should be this

• apple red
• apple red
• banana yellow
• apple red
• pear green
• banana yellow
• pear green

Answer 1

[Star Strider]

Not really certain what you want, but this should get you started:

C = [{'banana'} {'yellow'};
    {'apple'} {'red'};
    {'pear'} {'green'}];

Q = C{strcmp(C, 'apple'), 2}

[andrew]

So i would like to search through column 1 which is 1x821 matrix and use a strcmp to compare part of a string to the name in column 1. If there is a match I would like to print the information that is relevant to matched information in column 1

[Star Strider]

You have a 1-row by 821-column vector by your description.

The impression I got from your question is that you have a matrix and are getting the information on some of the elements in the rows that matched the information in the first column.