auto-populating columns
 

I have a column where I've defined a list through 'Data Validation'.
I'm trying to get it to automatically populate the two columns next to
it based on the selection of the value in the list.

i.e. each list selection has two corresponding values associated with
it.

I haven't done any Excel programming before - I've looked at the Fill
Series features and it doesn't seem to do what I need.

Not looking for step by step instructions - just a direction of which
way to head...


- Arash
www.digitalroom.net