Need help with returning values from excel sheel to another using cell address

[spittingfire]

I have two sheets: sheet1 and sheet2.

• In sheet2 I have a column "C" called addresses and in that column I have actual cell addresses such as $J$740, $H$756, etc, all referring to cell locations in Sheet1.
  
• In sheet1 in column "B" are names.

I would like to be able to return the names from sheet1 column "B" to column "G" of sheet2 that belong to the cell address from column "C" in sheet2.

Is there an Excel formula or vb script that will do this?

[spittingfire]

Hi all - I was able to find the answer to my question and it's below in case others are looking.

=OFFSET(Sheet1!B$1,RIGHT(C2,LEN(C2)-FIND("$",C2,2))-1,0)

credit given to mehmetcik from excel help