Conditional Validation

[Guest]

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]

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]

That solved the problem. Thanks!