Setting up Dynamic Drop Down with Multiple starting points

[accountingblonde]

Hey Everyone!

I am new here and am an intern this semester and have been tasked with something but I don't know if it is actually possible. It seems like it would be but I don't really know how to do it. I found a guide online on how to set up dynamic drop downs generally, but my supervisor is asking me for something a bit more specific.

The issue is that we have a large table that references other worksheets and they want the main sheet to be able to use a filter on any one column but to filter the other columns as well. So usually the dynamic drop downs would require that "Food Type" would be selected first and everything else is an Indirect statement referring to that so that the progression of filtering is from left to right. But would there be any way to start filtering at any column and limit the choices in the others. So say I wanted to filter on "Color" as Tan so then it would show me (depending on the way that the reference tables were built) that Wheat, Honey Wheat, and Oat were all tan types of bread, and that they could be a loaf or bun and could be a oat or wheat grain?

I am not sure that makes any sense but this is a difficult problem to describe. I just want to be able to filter from any point and limit the other fields rather than having to go in a set order of filtering.

Please help! I have tried to illustrate the issue with tables below!

Thanks!

[TABLE="width: 500"]
<tbody>[TR]
[TD]Food Type[/TD]
[TD]Bread[/TD]
[TD]Grain[/TD]
[TD]Color[/TD]
[TD]Loaf Type[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Rye[/TD]
[TD]Oat[/TD]
[TD]Brown[/TD]
[TD]Loaf[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Wheat[/TD]
[TD]Wheat[/TD]
[TD]White[/TD]
[TD]Roll[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Honey Wheat[/TD]
[TD]Rye[/TD]
[TD]Tan[/TD]
[TD]Bun[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]White[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Oat[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Food Type[/TD]
[TD]Bread[/TD]
[TD]Grain[/TD]
[TD]Color[/TD]
[TD]Loaf Type[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Rye[/TD]
[TD]Rye[/TD]
[TD]Brown[/TD]
[TD]Loaf[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Rye[/TD]
[TD]Rye[/TD]
[TD]Brown[/TD]
[TD]Roll[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Wheat[/TD]
[TD]Wheat[/TD]
[TD]Tan[/TD]
[TD]Loaf[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Wheat[/TD]
[TD]Wheat[/TD]
[TD]Tan[/TD]
[TD]Roll[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Wheat[/TD]
[TD]Wheat[/TD]
[TD]Tan[/TD]
[TD]Bun[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Honey Wheat[/TD]
[TD]Wheat[/TD]
[TD]Tan[/TD]
[TD]Loaf[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Honey Wheat[/TD]
[TD]Wheat[/TD]
[TD]Tan[/TD]
[TD]Bun[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]White[/TD]
[TD]Wheat[/TD]
[TD]White[/TD]
[TD]Loaf[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]White[/TD]
[TD]Wheat[/TD]
[TD]White[/TD]
[TD]Roll[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]White[/TD]
[TD]Wheat[/TD]
[TD]White[/TD]
[TD]Bun[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Oat[/TD]
[TD]Wheat[/TD]
[TD]Tan[/TD]
[TD]Loaf[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Oat[/TD]
[TD]Oat[/TD]
[TD]Tan[/TD]
[TD]Loaf[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Oat[/TD]
[TD]Oat[/TD]
[TD]Tan[/TD]
[TD]Roll[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Oat[/TD]
[TD]Oat[/TD]
[TD]Tan[/TD]
[TD]Bun[/TD]
[/TR]
</tbody>[/TABLE]


PS. If this is not possible, is there a way to achieve what I am trying to do? Thanks!

 

[accountingblonde]

Can anyone help with this please?