Fill a column with the contents of another column based on a choic

[Guest]

Is there a _simple_ way to fill a column with data from a group of columns
based on a drop-down selection?

Lets suppose we have a empty column that we want filled with information
that is based on a quick drop down selection. The user chooses an item from
a Data Validation List, then a column fills up depending on whitch item the
user selected.

Example:
Drop down choices = numbers, letters, months
source data column A1:A12=1...12
source data column B1:B12=A...L
source data column C1:C12=JAN...DEC

It could be done with an if-then series, but there should be a simple way to
do it.

 

[Anne Troy]

Yes. This should tell you how to do just what you need:
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************