Finding Corresponding Values In Cells

Hello,

I just wanted to get an opinion on the best way to approach a problem. I am importing an excel sheet which contains numbers and strings using xlsread. From the created cell I want to find a numerical value in the first column and then print the corresponding value from the second column.

Any tips on which functions to run would be much appreciated.

Thanks, Ross

Answer 1

[Azzi Abdelmalek]

v={1 'a';2 'b';'s' 'e';1 'e' ;4 'z'}
idx=cellfun(@isnumeric,v(:,1))
out=v(idx,2)

[Ross Westwood]

Thanks, cellfun might be what I am looking for, but the @isnumeric is not quite the right function. The user will input a value. For example, if you were to imagine it was patient records in the cell, it will ask for the patient number and display the corresponding height of that person. Any idea on what will be used for this?