How to “Autofill” on different column “B” UPON my selection on column “A”?

Dear all,


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

Leave a Reply

Your email address will not be published. Required fields are marked *