Results 1 to 11 of 11

display all row containing string from Both Dropdown list

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    9

    display all row containing string from Both Dropdown list

    hi,
    i have a list of data which contains Region ("West", "North") in first column, Circle ("Mumbai","Maharashtra","Delhi","Haryana") as second Column, and Friuts name in third column.
    1. with the help of Data validation i have made a Dropdown 1 which contains "west" & North"
    2. Second DropDown is ccreated which is dependent on first one. when the Value of first DropDown is "West" it will have list as "mumbai,"Maharshtra" and for "North" it will have list as "Delhi"&"Haryana"
    3. after selecting both drop down below is the table which will show Rows having values which is combined by both Dropdown Value

    for e.g. if the 1st Dropdown value is "West", and "Mumbai" is selected in second drop down, then table will contain as below


    Region | Circle   | Fruits
    -----------------------------
    West   | Mumbai | Mango
    West   | Mumbai | Apple
    West   | Mumbai | Grapes
    West   | Mumbai | Strawberry
    West   | Mumbai | Kiwi
    West   | Mumbai | Mango
    i have tried using vlookup but it display only one value.

    pl help.
    Last edited by pintusolanki1; 06-03-2017 at 04:26 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] display unique list in dropdown in each subsequent cell
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-04-2017, 10:12 AM
  2. Replies: 3
    Last Post: 12-15-2015, 12:14 PM
  3. [SOLVED] Display automatically particular list in dropdown
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-07-2014, 09:11 AM
  4. Display dropdown list after previous selection
    By norm188 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2013, 10:32 PM
  5. Display dropdown list in cell if condition is met
    By markiz in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-19-2013, 03:12 AM
  6. Dropdown List - Change Display
    By ewainscott in forum Excel General
    Replies: 2
    Last Post: 05-25-2007, 09:49 AM
  7. How do I change the size of font/display in a dropdown list I've .
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2005, 03:06 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