How to create a dashboard list

[mattyblueice]

I am working on a dashboard that I would like to use to display the product codes associated with a customer.

I created a selector cell with a dropdown to select the customer's name in cell C1 (used the list function under data validation). I have a table that contains all of the data - for my example I am simplified it.

What I would like to do would be for the product codes to populate downwards starting in Cell A7. So in the example here, I selected Smith as the customer and in the table Smith has codes B110 and C117 associated with him. So B110 would appear in B4 and C117 in B5.

Any ideas on how to set this up?[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: center"]Customer[/TD]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Product Code[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]B110[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]C117[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[macattackpro]

Hi,

I may be over-simplifying this but if your data is already in a table and all you would like to do is essentially "filter" that table's data then why not just insert a slicer?

 

[mattyblueice]

The data is located in another tab and I need something more clearer than a pivot table

 

[mattyblueice]

Any other ideas on this - I am trying to refresh this post, but I am unable to