See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Anya Blue" wrote in message
...
I want my user to choose from my drop down list and the next column appears
a
description. Example. Column A;A1 drop down list of numbers (1, 2, 3...).
The
user selects 1 and the next column (Column B;B1) automatically appears a
text
description.