Using cell contents as a row reference in a formula

[DilbertAsok]

Hi,
Bit of a strange one this.

In columns A to F I have formulas which reference another sheet. For example in row 1, column A my formula is "=Sheet2!B52", column B is "=Sheet2!E52", column C is "=Sheet2!K52", and so on.

Row 2 of my sheet references row 53, and so on down, but that won't always be the case. The next time I use this sheet row 1 will be looking at row 80 on Sheet2.

What I want to be able to do, is have column H on Sheet1 as the row number that I want the other formulas to reference on Sheet2.

I want my formula in cell Sheet1!A1 will do something like:

=Sheet2!B[ROW=H1]

so that the column reference of the cell I'm looking up is static, and the row reference determined by the contents of cell H1.

Possible?

Thx.

 

[Aladin Akyurek]

Something like...

=INDEX(Sheet2!B:B,H1)

 

[DilbertAsok]

So not only possible, but blindingly simple - the question to longer to write out!

Thank you!