Pick and display - is it possible?

[Onyxalis]

Hi,
I have a question about sorting and displaying.
I have a sheet containing spare parts and products that contain said parts.
Is there a way to choose a product and get the associated list of spare parts, for that product only?

Part A B C
001 x x x
002 x
003 x x
004 x x
005 x x
006 x x
007 x
008 x
009
010 x x
011 x
012 x
013 x x
014 x x x
015 x x x

If I pick product A, B or C (from a cell or drop list)I would like something like this:
A B C
1 1 1
3 5 2
4 6 3
5 8 4
6 10 7
11 12 10
13 14 13
14 15 14
15 15

Is this even possible?

Thanks in advance
//Jenny

[ramananhrm]

Are you expecting this result?

[Evolta]

Ok I saw this and just had to reply since I am kinda bored....
Read my answer only if NOONE ELSE is willing to reply. Watch the forums, I truly doubt that.
But I had fun and my function does seem to work haha xD

couldnotresist.xlsx

Apply on array: B4:E19 and data validation is in G4

Please Login or Register  to view this content.

[Onyxalis]

Yes!!!!
That is what I want. Thank you!

To make it even better:
Is it possible to pick a product from a roll down list and then display the spare part list for the choosen product only?

[ramananhrm]

Please try this file. (VBA part is not mine)

Please Login or Register  to view this content.

[Debraj Roy]

Hi Onyxalis,

If you are looking to display individual cell contain only found data..

you can go for this one also..

Please Login or Register  to view this content.

couldnotresist.xlsx

[Onyxalis]

Thank you all for your swift replies.
This is exactly what I was looking for. Now I just have to sit down and try to figure out how to apply it on my much larger data set.