DATA VALIDATION

[Guest]

IF I USED DATA VALIDATION TO CREATE A LIST. CAN I LINK TWO LISTS TOGETHER.
ie: LIST 1 IS ONLY COLORS, AND LIST 2 IS FRUIT. CAN I MAKE THE LISTS LINK
SO AN ERROR POPS UP IF I TRY TO SAY I HAVE A PURPLE, APPLE? WHEREAS THE
PROGRAM KNOWS, BECAUSE MY LISTS ARE LINKED THE ONLY COLOR THAT CAN BE BROUGHT
DOWN IN THE FIRST LIST IS RED. IF I TRY TO USE PURPLE IT WON'T ALLOW ME, OR
AUTOMATICALLY CHANGE IT TO THE COLOR RED.

 

[Roberto]

One way:
fit a table:

A B C
------------------------------
RED YELLOW GREEN
------------------------------
Apple Banana Grapes
Peer

Give a name: the range "Apple" is called "RED"; the range "Banana" is called "YELLOW"; the range
C2:C3 is called "GREEN".
Then, in column A put the validation: A1:C1.
The last step: in column B put the validation:
=INDIRECT(A1).
This way, once is selected in A1 "RED", automatically in B1 is allowed only the value "APPLE", and
so on.
Roberto

"LUVMEEDOO" <[email protected]> ha scritto nel messaggio
: IF I USED DATA VALIDATION TO CREATE A LIST. CAN I LINK TWO LISTS TOGETHER.
: ie: LIST 1 IS ONLY COLORS, AND LIST 2 IS FRUIT. CAN I MAKE THE LISTS LINK
: SO AN ERROR POPS UP IF I TRY TO SAY I HAVE A PURPLE, APPLE? WHEREAS THE
: PROGRAM KNOWS, BECAUSE MY LISTS ARE LINKED THE ONLY COLOR THAT CAN BE BROUGHT
: DOWN IN THE FIRST LIST IS RED. IF I TRY TO USE PURPLE IT WON'T ALLOW ME, OR
: AUTOMATICALLY CHANGE IT TO THE COLOR RED.

 

[Saruman]

Please stop shouting, I have a headache.


Sentence case is the accepted norm, whereas CAPITALS are considered to be
SHOUTING!!