I want to create a GUI with 3 drop down list with some values. when we select the input values from the drop down list, it has to search the values from excel sheet. when both the input values are matched in the excel sheet then it has to display the corresponding 4th column value.
example
A B C D----------------------------------xxx xxx xxx First rowxxz yyy abc Second rowxyz yyy zzz third rowyyy xxx xyz Fourth rowzzz abc xxx fifth row
these are the values in excel sheet. suppose if i select
xxx yyy abc from the drop down list then the output is "Second row".
please help me
Best Answer