Forum Discussion

Brad_C43's avatar
Brad_C43
Copper Contributor
Mar 27, 2025
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 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 ) )

     

Resources