+ Reply to Thread
Results 1 to 3 of 3

Search results based on two validation lists

  1. #1
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Χαμένος στο διάστημα
    MS-Off Ver
    2016
    Posts
    383

    Search results based on two validation lists

    Hello all,
    i have two drop down lists and when i select the contents from drop down, i need to take in a cell some numbers. These numbers exists, in other sheet to choices of drop down lists.
    In my book i have an example but ranges are for this example only.
    Thanks in advance for your help
    Attached Files Attached Files
    Last edited by Immortal2014; 08-07-2018 at 01:42 PM.
    Nick

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Get number according choices from two drop down lists

    =VLOOKUP(x!B3&x!C3,OFFSET(u!$A$3,,MATCH(x!B3&"*",u!B3:L3,),10,2),2,)
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Χαμένος στο διάστημα
    MS-Off Ver
    2016
    Posts
    383

    Re: Get number according choices from two drop down lists

    Hello, tim thanks for your answer.
    Forgive me because i did not correctly articulate what i need.
    In the new book i attach, i explain exactly what i am asking, in the real areas of my original book.
    Thanks again
    Attached Files Attached Files

+ 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. [SOLVED] Search in long data validation lists
    By VisionSmart in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2017, 09:57 PM
  2. Search Data Validation Lists
    By Dinger045 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2015, 09:21 AM
  3. Replies: 0
    Last Post: 06-16-2013, 10:46 AM
  4. How can I make new lists based on results from other lists?
    By wardlowe in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-02-2013, 12:36 AM
  5. creating VB code using advanced search criteria with multiple data validation lists?
    By Jonathan Bay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2011, 09:56 AM
  6. Something changed my Data Validation lists. Is Search and Substitute Possible?
    By homasa in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-20-2010, 09:09 AM
  7. Trying to create complex list results, using validation lists, etc...
    By semantik in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-28-2007, 07:56 PM

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