Helo, Can anybody help me with Drop down list.
I know how to create drop down list but I have a problem to Return different value then is displayed in Dropdown List. For example:
On the workbook I have two wokssheets: one with empty cell and secound with list created for dropdown list.

On the secound woksheet I have created: column A namebox "Country" - cointains full name of countries (Great Britain, Australia ...) and column B namebox "CountryCode" - contains country codes only (GBR, AUS ...)
When I click on dorp down list on first worksheet, I would like to my drop down list display me list with columnA "Country" but when I choose one of that it would returns me cell from columnB "Country Code".
Is there any easy way to do that?