Forum Discussion
raphazzz
Mar 21, 2023Copper Contributor
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 ...
HansVogelaar
Mar 21, 2023MVP
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.