We have data pertaining to the amount and order we have recieved segregated based on location and mediums like Website and Facebook. I am building a summary sheets that will display selected information from the other sheet for a particular location. I tried using VlookUp but that does not working with drop downs.
Drop-down list:
Website - Whitefield
Mobile - Whitefield
I want specific data from another sheet to populate on the summary sheet once a value is selected from the drop-down.
Below is a reference to the data.
Website - Location
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Total Orders[/TD]
[TD]Amount Spent[/TD]
[TD]Cost Per Conversion[/TD]
[TD]Const Per Acquisition[/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]15[/TD]
[TD]1800[/TD]
[TD]1800/15[/TD]
[TD]1800/New Orders[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What I want is when some one selects Website - Location in the drop down on the summary sheet, the above table should appear. Similarly, it should repeat for other options in the drop down with same headers.
Drop-down list:
Website - Whitefield
Mobile - Whitefield
I want specific data from another sheet to populate on the summary sheet once a value is selected from the drop-down.
Below is a reference to the data.
Website - Location
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Total Orders[/TD]
[TD]Amount Spent[/TD]
[TD]Cost Per Conversion[/TD]
[TD]Const Per Acquisition[/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]15[/TD]
[TD]1800[/TD]
[TD]1800/15[/TD]
[TD]1800/New Orders[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What I want is when some one selects Website - Location in the drop down on the summary sheet, the above table should appear. Similarly, it should repeat for other options in the drop down with same headers.