cell to sheet
 

I have various tabs example one named HGI

I want to have a formula that will look at cell B1 of a sheet i specify
in a cell

example report page cel A1 = HGI

I want cell A2 to look at cell B1 of the sheet that is named in A1


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=565543

cell to sheet
 

ceemo wrote:

I have various tabs example one named HGI

I want to have a formula that will look at cell B1 of a sheet i specify
in a cell

example report page cel A1 = HGI

I want cell A2 to look at cell B1 of the sheet that is named in A1

Hi ceemo

Try this in A2:

=INDIRECT(ADDRESS(1,2,,,A1))

Regards

Steve

cell to sheet
 

If A1 contains the name of the sheet, you can use this to return the value in
x99 of that sheet.

=indirect("'" & A1 & "'!x99")



ceemo wrote:

I have various tabs example one named HGI

I want to have a formula that will look at cell B1 of a sheet i specify
in a cell

example report page cel A1 = HGI

I want cell A2 to look at cell B1 of the sheet that is named in A1

--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=565543

--

Dave Peterson

cell to sheet
 

nice thanks alot for the tip. Will it alo work in an offset function
when reffering to a starting cell or selection column


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=565543

cell to sheet
 

Will it alo work in an offset function when reffering to a starting cell
or selection column


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=565543

cell to sheet
 

What happens when you tried it?

ceemo wrote:

Will it alo work in an offset function when reffering to a starting cell
or selection column

--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=565543

--

Dave Peterson