how do i do 3 data validations?

[Guest]

If i have a cell C18 with list values "25-51-91","25-51-82","25-51-54"
"25-51-55","25-50-23"

a cell c19 with list values"0", "1", "E"

and cell C8 values "UA 115180-4, UA 115169-1,UA 115169-5, UA 115163-5H,
3DF-A35-11D-G"

and when i select C8= UA 115180-4 ,c18 should be "25-51-91" c19 should be 0

when i select UA 115169-1,UA 115169-5, UA 115163-5H c18 shld be
25-51-82,25-51-54,25-51-55 cell c19 value should be 1

when i select 3DF-A35-11D-G" c19 should be 25-50-23 c19 value should be E

How can i get it automatically done? so that when i select the value for c8
then the values for c18 and c19 is auto generated ? or vice versa when i
select c19, the rest of the 3 are auto changed


Yvannia

 

[Dave Peterson]

I would think that you could use data|validation in C8 and formulas in C18 and
C19 (kind of what was suggested at your first post).

 

[Dave Peterson]

But formulas won't change values in other cells. You'd have to use some kind of
macro to do the changes to the other cells.

Personally, I think keeping one cell for input (C8) and using formulas in C18 &
C19 would be more straightforward for the user, too.

I'd even lock those cells with the formulas and protect the worksheet so that
the user can't change C18:C19.