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=KOR,ClashIssues,ClashIssuesEng)
However, if I change the language, 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. What can I do to make this dropdown change?
Any help with this is great!
For reference, I am using Excel 2010.
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=KOR,ClashIssues,ClashIssuesEng)
However, if I change the language, 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. What can I do to make this dropdown change?
Any help with this is great!
For reference, I am using Excel 2010.
Last edited: