Assuming Column A has been set with Data Validation function which provides me the convenience of having a set of datas to select, i wish details of data chosen in Column A to be automatically shown in Column B.
In order words, data in Column B to be corresponding to the option chosen in Column A.
Column A comes with options of Eat, Drink and Play.
When i choose Eat in Column A, Column B shows “Eat Bread”
When i choose Drink in Column A, Column B shows “Drink Soda”
When i chose Play in Column A, Column B shows “Play video games”
Is Excel able to do this and what steps or formulas i should use to make this automation happens?
By: Eric Leong