how to find the corresponding elements in a matrix/excel

Like if I name the Stage 2 then it should display the disease name(Alternaria leafspot) occuring at that stage. Sample file attached

[Image Analyst]

If you name what "the Stage 2"? Display the disease name how???? On a GUI? In the command window? In the workspace panel?

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

[Aiman Zara]

@Image Analyst In a given table, if I select any element and need to find a value related to that specific element from another row or coloumn, how would I do that? can you provide me a sample code of doing that?

the output should be displayed in the command window

Answer 1

[Image Analyst]

Try this:

t = readtable('FinalBookExcel.csv')

Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.

t = 5×3 table
    CottonStage    DiseaseSeverity            Disease        
    ___________    _______________    _______________________

    {'Stage1'}      {'harmful' }      {'Fusarium wilt'      }
    {'Stage2'}      {'harmful' }      {'Alternaria leafspot'}
    {'Stage3'}      {'Critical'}      {'Fusarium wilt'      }
    {'Stage4'}      {'Medium'  }      {'Fungal'             }
    {'Stage5'}      {'Medium'  }      {'worm'               }

% Lets specify row 2, column 1 and get the value there.
row = 2;
t21 = t.CottonStage(row)

t21 = 1×1 cell array
    {'Stage2'}

% Now let's get the "DiseaseSeverity" value for that same row
t22 = t.DiseaseSeverity(row)

t22 = 1×1 cell array
    {'harmful'}

% Now let's get the "Disease" value for that same row
t23 = t.Disease(row)

t23 = 1×1 cell array
    {'Alternaria leafspot'}