+ Reply to Thread
Results 1 to 3 of 3

Compare and restrict available numbers in two lists

Hybrid View

  1. 11-20-2007, 05:45 PM #1
    jpp8596
    jpp8596 is offline
    Registered User
    Join Date
    11-19-2007
    Posts
    4

    Compare and restrict available numbers in two lists

    I have two lists of numbers, with each list being generated by it's own =INDIRECT function. I want to be able to select a number from list one, let's say 10, 20, 30, 40, and 50 are the numbers in the list. Then the second list is the same, but I need to restrict the available values. So if 10 is picked in list 1, then only 10 is available to pick in list 2; if 40 is picked in list 1, then in list 2 you can choose from 10, 20, 30, or 40.

    Any help on making this work is appricitated!
    Thanks
    Last edited by jpp8596; 11-20-2007 at 08:28 PM.
    Reply With QuoteRegister To Reply
  2. 11-21-2007, 07:02 AM #2
    Gary Brown
    Gary Brown is offline
    Forum Contributor
    Join Date
    12-02-2004
    Location
    London
    Posts
    255
    Have a look at the attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 11-21-2007, 01:54 PM #3
    jpp8596
    jpp8596 is offline
    Registered User
    Join Date
    11-19-2007
    Posts
    4
    Wow, I thought there would be something much simpler, some function that I just didn't know about. It is going to be a pain in the @$$ to integrate this, but you have me pointed in the right direction. Thanks a bunch!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1