Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Conditional Validation

  1. #1
    Guest

    Default

    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.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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)



  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That solved the problem. Thanks!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •