Using dependency matrix to look up values - help

[LouieP]

Hi all,
I've been stuck for a couple of days trying to get a dropdown box to do what I want it to do - to no avail.

I have four products A, B, C, D that are dependent on a mixture of 9 components and I would like to sort their dependency using a dropdown box.

like:

  A B C D
1 x  x x
2 x   x
3 x x x x
4     x x 
5 x  x x
6     x
7 x x  x
8   x   x
9 x x x

If I selected A from a combobox it would display 1,2,3,5,7,9
I've been looking at pivot tables but I don't understand them yet.

Any help would be amazing!

Louie

 

[SteveO59L]

Use an autofilter ?

 

[LouieP]

Use an autofilter ?

I would normally use a filter to sort through the info but this needs to be more powerful since the returned values of the search are involved in another process.

Below is what I am trying to get at where rows 2-10 are E,F,G,H....