Forum Discussion
How to return a cell value (vertical) from a row based a cell value?
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 ...
=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.