Forum Discussion
Brad_C43
Mar 27, 2025Copper Contributor
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 both a front and rear ride height value with excel then retrieving the corresponding force from the table.
Thanks in advance for any help!
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 ) )
- Brad_C43Copper Contributor
Awesome, thank you