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.- with the help of Data validation i have made a Dropdown 1 which contains "west" & North"
- 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"
- 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.
Bookmarks