How to return a cell value (vertical) from a row based a cell value?

[raphazzz]

Hello friends,

I have the following excel sheet that I'm trying to return the following data:

Any ideas how to do that? I don't have too much flexibility to change the layout of the excel file but I might be able to do minor changes.

Thanks

[#2]

@raphazzz 

=INDEX($G$3:$P$3,MATCH(MAX(G7:P7),G7:P7,0)-1)

You can try this formula in cell D7.

=INDEX($G$3:$P$3,MATCH(MIN(G7:P7),G7:P7,0)-1)

You can try this formula in cell F7.

Both formulas can be filled down as required.

[#3]

@raphazzz 

In D7:

=INDEX($G$3:$O$3, MATCH(C7, $H7:$P7, 0))

In F7:

=INDEX($G$3:$O$3, MATCH(E7, $H7:$P7, 0))

Fill down to row 9.