Is there an alnernative to index match?

OK,

Please see attached - I am looking for the simplest possible formula to do the job. (For training purposes)

I have the two yellow variants, and wish to return the green answer. The Part numbers can be in a random order and so can the columns.

Many thanks :-)