Hi there,

First I just want to thank all you awesome members out there. Through your assistance with others, I have learned a lot about excel.

Now, to the problem.
I am working on a bilingual file and want to display the results dependant upon the language selected.
I have a drop down selection list set up through data validation. When the drop down is selected, it displays according to the language selected, with this formula
=IF(Lang=x,lista,listb)
However, if I change the language after selecting an item from the dropdown, the preselected item does not change according to the language. I need this to change because I have other cells referencing this cell as a lookup value. I also need this input cell to be the active cell... in otherwords, I can't use a dummy cell somewhere else and reference to it. What can I do to make this dropdown change?

Any help with this is great!
For reference, I am using Excel 2010.