Hi,

This is very useful for something I am trying to sort out too, cheers.

Is it possible to select from the drop down and have items appear on a
separate rows as in the demonstration, but to also fill out associated cols.

So if in the List validation it looks at AA1:AA10, and returns the selected
item into column B, could it at the same time return into column C what is
against the selected item in AB1:AB10?

I hope I have explained that clearly enough! - I imagine it would involve
somekind of lookup? - I don't want to have any formulas etc in the C col
until something appears in the B column.

Thanks

Peter

"Phil(tech)" wrote:

I was given a strange query from one of my users today in Excel, and I must
admit I found myself clueless as to how to help her. Basically she wants to
create a drop down list (easy to do), when she makes a selection on that list
she wants it to appear in a different cell (not so easy), on top of that,
once she has made that selection, she then wants to click on the same list
again and make a different selection and have that appear on the same cell as
the before, but with a comma seperating the two selections. Is there any way
to do this?