cell to sheet

C

ceemo

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
 
B

britwiz

ceemo said:
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
Click to expand...
Hi ceemo

Try this in A2:

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

Regards

Steve
 
D

Dave Peterson

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

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

ceemo

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

ceemo

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