Use value in a function

[Scott]

Hi,

I'm trying to use the following function to retrieve
information from a list in column A in which the location
can vary.

=OFFSET(A28,1,0)

The problem is the A28 reference needs to be the value of a
formula.

I use this function to find the row number of known information
=MATCH(E8,A1:A45,0) ;E8 is known info

and use this to put together the cell reference - A28
=CONCATENATE("A",F10) ;F10 is MATCH function

Then use the OFFSET function to get the required info from
the row below the known info. But I can't figure out how
to use this cell reference in the OFFSET function above.

Any ideas? Is there another way of doing this?

Thanks