Forum Discussion
Solved
Retrieving a value from a two way table
Hi everyone, I was just wondering if there was a function which would allow me to retrieve a specific value from a two way table as seen below. As seen above I would like to be able to input b...
As variant
=INDEX( INDEX($W$120:$AL$127, 0, MATCH($W$131,$W$119:$AL$119,0) ), MATCH( $X$131, $V$120:$V$127, 0 ) )
As variant
=INDEX( INDEX($W$120:$AL$127, 0, MATCH($W$131,$W$119:$AL$119,0) ), MATCH( $X$131, $V$120:$V$127, 0 ) )
Awesome, thank you