ok. i will look into this later.... but here if u can help me with 2 other problem.
1- in drop down menu, if have all letters in proper way.
like 'Apple' 'Orange'
if someone type 'apple' or 'ORANGE' then how to arrange these letters properly to 'Apple' 'Orange'
2- in cell a1 there is a pulldown menu with several options. i want help to to read it using if condition.
e.g. if someone select from puldown menu 'Apple' or 'Orange' then i want in cell a2 'Fruit' and if something is selecting from pulldown menu like 'Lady Finger' or 'Onion' then i want 'Vegetable' to be shown in cell a2