How to reference the returned row # from a Match function in a separate formula

[tracey.king]

If I use the match function to find the first row of a specific range, within a very large range of values, how can that row be referenced in a separate formula returning the value of the number in that row?

For example:  Sheet1 has 6,000 rows of data in multiple columns with the dollar values in column H.  On Sheet2 in cell B1, the match function is used to return the first row # of a specific range of criteria listed on Sheet1.  The row # returned on 'Sheet2'!B1 is 5,000.  

How can the returned row # on 'Sheet2'!B1 be referenced in a separate cell formula on 'Sheet2'B3 to return the value in 'Sheet1'!H5000?  

I thought the formula in 'Sheet2'!B3 would be ='Sheet1'!H('Sheet2'!B1) but this returns an error of #NAME?

[#2]

Hi Tracey,

That could be for example

=OFFSET(Sheet1!H1,Sheet2!B1-1,0)

[#3]

Thanks Sergei!  That worked!