Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005

    Unanswered: can you identify the Range Validation index

    Hello to All,

    Ok, here is what I am trying to do. I have one field B2 that is set up for validation to a range of fields that contain Zip-codes. say M1-M500. Now I want to set up another field to use validation off of the first field B2 but use B2's index plus one row. So say they selected the zip code in the drop down box in B2 that the value is in M5. I want A2 to automaticly populate with B2's index which is set to M5 to then populate the data that is in N5.

    To try to give an example. Because I selected 79604 from the validation drop down A then populates with the D column of the same row as the choses in B.

    A B C D
    Abilene 79604 02169 Quincy
    79510 Clyde
    79604 Abilene

    Thanks for all the help and I hope I wasn't too confusing.


  2. #2
    Join Date
    Oct 2003
    Howdy. yes, it can be done. Debra Dalgleish has some excellent instructions:
    Dependent Validation Lists.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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