DATA VALIDATION
 

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.

DATA VALIDATION
 

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" 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.

DATA VALIDATION
 

Please stop shouting, I have a headache.


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

--

Saruman
---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------


"LUVMEEDOO" wrote in message
...
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.