Results 1 to 5 of 5

Allow Free Form with Double Validation List

Threaded View

maacmaac Allow Free Form with Double... 03-09-2010, 12:43 PM
NBVC Re: Allow Free Form with... 03-09-2010, 12:51 PM
maacmaac Re: Allow Free Form with... 03-09-2010, 01:16 PM
NBVC Re: Allow Free Form with... 03-09-2010, 01:35 PM
maacmaac Re: Allow Free Form with... 03-09-2010, 02:14 PM
  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    Allow Free Form with Double Validation List

    I have two columns I am using in a spreadsheet, which each have validation rules (columns I & J).

    Column I = Industry
    Column J = Occupation

    The validation from column J is dependent on the validation in column I. For example, if user chooses "Airlines" as an industry, then the choices in column I (Occupation) would be "Air Controller, Pilot, Mechanic, etc."

    One of the choices in column J is "Other". If the user makes the choice of "Other", then the user should be allowed to type into column I (Occupation) anything they want.

    How can I update may validation tables to allow this? I have added example if needed. Thanks for any comments.
    Attached Files Attached Files
    Last edited by maacmaac; 03-09-2010 at 02:15 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1