PDA

View Full Version : [SOLVED] Need help with returning values from excel sheel to another using cell address



spittingfire
08-16-2014, 02:29 PM
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
08-16-2014, 03:35 PM
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