create two list boxes and display the output in text box in GUI

in list box1 (Semester - I) the contents are

Drop Fail Pass Third class Second Class First Class Distinction

in list box2 (Semester - II)the contents are

Drop Fail Pass Third class Second Class First Class Distinction

Now i want to display the grade in text box based on the inputs from the user

these contents are saved in a excel sheet

Drop Drop F grade Drop Fail F grade Drop Pass F grade Drop Third class E grade Drop Second Class E grade Drop First Class E grade Drop Distinction D grade Fail Drop F grade Fail Fail E grade Fail Pass E grade Fail Third class E grade Fail Second Class D grade Fail First Class D grade Fail Distinction D grade Pass Drop F grade Pass Fail E grade Pass Pass E grade Pass Third class D grade Pass Second Class D grade Pass First Class D grade Pass Distinction C grade Third class Drop E grade Third class Fail E grade Third class Pass E grade Third class Third class D grade Third class Second Class D grade Third class First Class D grade Third class Distinction C grade Second Class Drop D grade Second Class Fail D grade Second Class Pass D grade Second Class Third class C grade Second Class Second Class C grade Second Class First Class C grade Second Class Distinction B grade First Class Drop D grade First Class Fail C grade First Class Pass C grade First Class Third class B grade First Class Second Class B grade First Class First Class A grade First Class Distinction A grade Distinction Drop D grade Distinction Fail D grade Distinction Pass C grade Distinction Third class C grade Distinction Second Class B grade Distinction First Class A grade Distinction Distinction Excellent

[Mary]

Any One pls. answer this question....

[Mary]

Is It Possible with listbox in matlab gui? or any other suggestions...?

[Jan]

I do not understand the question. There are two identical strings as inputs, perhaps in list-boxes, and a large string or tables of strings in an Excel sheet. Perhaps it is only the missing formatting, but currently it is impossible to understand, what you have as inputs, which procedure you want and how the wanted output should look like.

Please do not bump your question after some hours. When the readers do not know an answer, reading the question again without any new information wastes time. A lack of answers is usually a secure sign of too few information in the question, but in no case the reason is, that the contributors read your question not frequently enough.

Please read http://www.mathworks.com/matlabcentral/answers/6200-tutorial-how-to-ask-a-question-on-answers-and-get-a-fast-answer

[Mary]

First, Sorry for my unclear question.

i have a excel sheet which is having 3 columns each column is having the student information.

1st and 2nd columns are having the semester-I and semester-II status respectively like "pass", "Fail", "Distinction", "first", "second", "third class"..etc

In my GUI, i have two list box which is for sem-I and Sem-II marks. if i select any input from the both list box then it has to compare with the excel sheet row values.

once both the list box inputs are found in the excel sheet, then it has to display the 3rd column value as the output

for example

if i select "distinction" from 1st list box and "Fail" from 2nd listbox then it has to show the corresponding value from the 3rd column...