+ Reply to Thread
Results 1 to 1 of 1

Conditional Dropdown List Help

  1. #1
    Registered User
    Join Date
    07-22-2015
    Location
    New Jersey
    MS-Off Ver
    2010
    Posts
    12

    Conditional Dropdown List Help

    Hello All,

    I need some help creating a conditional drop-down list. I attached an example spreadsheet to show you what I am working with. Basically I need three different drop-downs containing the names in Info 1 that generates in d3:e3, f3:g3, and h3:i3. The tricky part is I only want names to show in that drop-down if they are within 1 value from the Like ID (found on the second tab). I.E. if name 4 is chosen and has a Like ID of 122 then I want the three drop-downs to show only Names that have a like id of 121,122, 123. Any name can be chosen in drop-down b3:c3. The like ID is based on three different criteria that determines the similarity of customer tendencies.
    Thank you in advanced for any help you can provide to me. Your help is greatly appreciated. Hope everyone has a great day!

    Example.xlsx

    I was able to do a round about way adding columns to the sheet one and an array function returning only unique matching names. If anyone wants to see my results please let me know!
    Last edited by blind099; 10-20-2015 at 03:18 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Dropdown List
    By chirag2709 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 11-04-2014, 06:11 PM
  2. [SOLVED] 2 Conditional Dropdown List Help Please
    By rck3 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-11-2014, 12:55 AM
  3. Problem getting conditional formatted dropdown list items to keep their formatting in list
    By scottatbuckman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2014, 02:39 PM
  4. [SOLVED] Conditional Formatting of List based on selections from Dropdown list
    By FoxyPinkChick in forum Excel General
    Replies: 4
    Last Post: 05-31-2013, 03:32 AM
  5. Need help with dropdown list with IF conditional
    By gulagulaimoet in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-06-2013, 05:28 AM
  6. Conditional Dropdown/list
    By hektisk in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-21-2011, 09:35 PM
  7. Conditional in-cell dropdown list
    By SKAh in forum Excel General
    Replies: 1
    Last Post: 03-25-2005, 05:05 PM

Tags for this Thread

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