MATLAB: Search for an element in cell array

cell arraysdatafindrow

So I have a dataset as follows
       NaN      51.1512    4.0000    6.0000
       NaN      80.7646    3.0000    6.0000
       NaN      89.3755    2.0000    6.0000
       NaN      96.3119    1.0000    6.0000
       NaN      51.1512    8.0000    5.0000
       NaN      80.7646    7.0000    5.0000
       5.1104   89.3755    6.0000    5.0000
       NaN      96.3119    5.0000    5.0000
       9.0177   51.1512   12.0000    4.0000
       NaN      80.7646   11.0000    4.0000
       5.3294   89.3755   10.0000    4.0000
now, I want the element in row 3, for a value of say 5 from row 4 and a value of 89.3755 of row 2, which is 6.0000.
Can you tell me how to do that? Thanks!

Best Answer

A=[NaN      51.1512    4.0000    6.0000
     NaN      80.7646    3.0000    6.0000
     NaN      89.3755    2.0000    6.0000
     NaN      96.3119    1.0000    6.0000
     NaN      51.1512    8.0000    5.0000
     NaN      80.7646    7.0000    5.0000
     5.1104   89.3755    6.0000    5.0000
     NaN      96.3119    5.0000    5.0000
     9.0177   51.1512   12.0000    4.0000
     NaN      80.7646   11.0000    4.0000
     5.3294   89.3755   10.0000    4.0000]
 idx=find(ismember(A(:,2),89.3755)&ismember(A(:,4),6))
 out=A(idx,:)
Related Question