Formula that list all the duplicates from column A if found any duplicate in column C

Hello guys,

First time on this forum, searching for help . I will very grateful if you can help me solve this formula.

So, I have this table with multiple products, and sometimes 2 or 3 products share the same components.
I attached an example with few products. In the example you will find a search box and a formula that list all the lines with the order number typed in that serch box.
For example, the order 907900 has a common component with order nr. 907920, and what I need is a formula to show me all the components from both orders 907900 and 907920.

Please help me guys. Thank you in advance!

You want to show just the orders that have same component number?
how does it tie to your search cell?

hello belinda200,

thank you for your fast replay.

if I search one order, I want to show me all the orders with all thry'r components that has 1 or more common components as the order that I'm searching.

I'm sure there must be a simpler way, but it's late in the evening, so my brains shutting down.
=FILTER(A2:D22,ISNUMBER(MATCH(A2:A22,FILTER(A2:A22,ISNUMBER(MATCH(C2:C22,FILTER(C2:C22,(A2:A22=G2)),0))),0)))