Conditional Validation

Mar 4th, 2002, 11:26 PM

I need to make drop-down lists for cells in column B correspond to values entered in column A. For instance, if "dogs" is entered in A, then the adjacent cell in column B would provide a list of dog breeds, and if "Cats" is entered in A, then a drop-down list of types of cats would appear in column B.

Aladin Akyurek · Mar 4th, 2002, 11:44 PM

Quote:

On 2002-03-04 23:26, Anonymous wrote:
I need to make drop-down lists for cells in column B correspond to values entered in column A. For instance, if "dogs" is entered in A, then the adjacent cell in column B would provide a list of dog breeds, and if "Cats" is entered in A, then a drop-down list of types of cats would appear in column B.

Assumnig that you have a list of dog breeds and you gave this list the name "dogs" via the Name Box on the Formula Bar and done the same with "cats", and supposing that A1 is an entry cell,

set up data validation in B1 with List for Allow and with as formula:

=INDIRECT(A1)

Rob · Mar 5th, 2002, 01:44 AM

That solved the problem. Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 11:26 PM	#1
Guest Posts: n/a	I need to make drop-down lists for cells in column B correspond to values entered in column A. For instance, if "dogs" is entered in A, then the adjacent cell in column B would provide a list of dog breeds, and if "Cats" is entered in A, then a drop-down list of types of cats would appear in column B.

Mar 5th, 2002, 01:44 AM	#3
Rob New Member Join Date: Mar 2002 Posts: 1	That solved the problem. Thanks!