using a calculated value as a row number
This should be easy, but I know I'm missing something.
I'm calculating a row number. The formula (using the MATCH function) has been tested and the correct value is displayed in a cell.
Now I need to incorporate that value into a cell reference so I can get the contents of the cell I'm looking for.
Here's the idea. The row number value is in cell B2.
=Sheet 2::Table 1::B(VALUE(B2)) which generates a syntax error.
I've tried a few variations on the above. All lead to dead ends.
So, can someone let me know how to construct this reference ?
Thanks.