Two-way Xlookup

Hello,
Could you please help me figure out how to make xlookup (or perhaps other function) to match the Part ID and the Column Name and insert the appropriate Part Name into the Appropriate Column?

two way xlookup.JPG
Data
Part ID Part Name Column Name
710 US-MADAC-18M Evolution
710 BHMA18M-TF Eliminator TF
710 BHMA18M Eliminator BP
710 AG-MADAC-18M Channel Flow

Result
Part ID Evolution Channel Flow Eliminator BP Eliminator TF
710 US-MADAC-18M AG-MADAC-18M BHMA18M BHMA18M-TF

Thank you

Did you mean B$9 (instead of B$10)?
=INDEX($B$3:$B$6,MATCH(1,INDEX(($A$3:$A$6=$A10)*($C$3:$C$6=B$10),0),0))
When I changed that it worked perfectly! Thank you so much!

Sorry, yes, B$9 rather than B$10.

Another option using dynamic arrays in MS365. Let's say your Data consists of many IDs (just going down to A10 for this example). And let's say your results should show up next to your list (say in column E is where the list of unique part numbers would start and then F:I are your column Names. You could then show your results with 2 formulas in 2 cells, no copying down or across.

E3 is this example would be:
=UNIQUE(A3:A10)

And F3 would be:
=XLOOKUP(E3#&F2:I2,A3:A10&C3:C10,B3:B10,"",0)

The results would SPILL as much as needed.

See attached.

Awesome! Thank you very much!