+ Reply to Thread
Results 1 to 7 of 7

Data Validation : 2 Lists dependant on selection with vlookup for 3rd value

  1. 04-26-2014, 11:28 AM #1
    scwillyb
    scwillyb is offline
    Registered User
    Join Date
    04-26-2014
    Location
    atlanta, georgia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Exclamation Data Validation : 2 Lists dependant on selection with vlookup for 3rd value

    Hello all,

    I am struggling to get my formula to run properly. I have a drop down list in column 'A' that will allow me to select corresponding values in this list in Column 'C'. In Column 'F' I need to be able to run a vlookup that is dependent on both of my list selections, as the second value (column 'C') appears in multiple 1st item lists (which is why I can't run a straight vlookup).

    I have browsed some of the other examples that deal with this and have tried an offset with an indirect but I am getting an error at this point. Any help you can provide would be much appreciated.

    Regards,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-26-2014, 11:49 AM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,732

    Re: Data Validation : 2 Lists dependant on selection with vlookup for 3rd value

    if you setup the table correctly so that one column in the table matches column A and the other column C
    then you could use something like

    =INDEX(Sheet2!C:C,MATCH(A6&C6,Sheet2!A:A&Sheet2!B:B,0))
    use control+shift+enter

    I have removed the validation and put the exact value from column A and from column B
    into Sheet1 A and C
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 04-26-2014, 11:57 AM #3
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Data Validation : 2 Lists dependant on selection with vlookup for 3rd value

    Looks like etaf beat be to the punch again , but attached is my solution.

    BSB.
    Reply With QuoteRegister To Reply
  4. 04-26-2014, 12:04 PM #4
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,732

    Re: Data Validation : 2 Lists dependant on selection with vlookup for 3rd value

    But, you did notice its B column to match and not A column, my bad .... thanks
    Reply With QuoteRegister To Reply
  5. 04-26-2014, 12:04 PM #5
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Data Validation : 2 Lists dependant on selection with vlookup for 3rd value

    Hi,

    Try this modified formula that uses a concatenated column instead of offsets...
    Attached Files Attached Files
    Regards,
    Rudi
    Reply With QuoteRegister To Reply
  6. 04-26-2014, 02:22 PM #6
    scwillyb
    scwillyb is offline
    Registered User
    Join Date
    04-26-2014
    Location
    atlanta, georgia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Data Validation : 2 Lists dependant on selection with vlookup for 3rd value

    Much appreciated all. All 3 methods work just fine for what I need. Wish I had time to study the methodology behind them so that I could become proficient at this going forward!

    Regards,
    Reply With QuoteRegister To Reply
  7. 04-26-2014, 02:25 PM #7
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,732

    Re: Data Validation : 2 Lists dependant on selection with vlookup for 3rd value

    your welcome , thanks for the rep
    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)

Similar Threads

  1. [SOLVED] Dependant Data Validation - Numbers NOT Lists
    By TC1980 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2014, 08:20 AM
  2. Data Validation. Multiple Dependant Lists Required
    By David_Schop in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2013, 07:35 AM
  3. [SOLVED] Data Validation - dependant lists - With a number value
    By philwilliams80 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-11-2013, 06:02 AM
  4. Resolved >>> Data Validation dropdowns (Dependant Lists)
    By Zhola in forum Excel General
    Replies: 3
    Last Post: 10-22-2007, 12:14 PM
  5. Data Validation Lists and dependant formulas HELP!
    By bnesswild in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2007, 02:09 AM

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