Anyone an idea how to solve this?

example:

I have 3 identical tables underneath each other, exactly similar.

in the left corner of the table is the name of that portfolio.

10 rows under that name and 1 column to the right is the total, which I am interested in.

now I am looking for a formula like this:

=offset(cell reference,9,1)

The problem (and my question) is to come up with a flexibel formula which gives me the cell reference (say A1) based on the lookup function on the name of the portfolio, which is located in the left corner.

Tx.