#5 Conditional Lookup using JXL

[Sabu S]

I am facing a problem in JXL.
I created a excel file with combo box. The requirement is if I change the value in one cell drop down then the value in another cell drop down has to change.
I could able to generate the excel sheet but the functionality is not working properly.
In the attached excel sheet Column F 'EMPLOYEE ROLE' having a list of Roles. Based on the selection next column G 'ROLE VALUE' drop down has to populate.
After selecting the value 'LBUC' or 'LBUM' (data is avilable for only these values) the value in the next column will fill with value from Columns L and M.
In first two rows this functionality working, because I manually corrected the problem in excel for your understanding.
After selecting values in F4..F400 if I select corresponding row value in G4..G400 no data is available.
What I have to do is select 'LBUM' or 'LBUC' from column G and click on column F, then from the Data menu select Validation, then with out changing any thing
click OK button. Now that cell is ready. If I select 'LBUM' I will get '3101,3102......' and if I select 'LBUC' I will get 'CN,IN......'.

I am using JXL 2.6.10. My source code and excel file also attached for your reference. This is an urgent requirement.
Please help me

[Sabu S]

My Source code

[Sabu S]

Sample File