B12!B22

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I know that SheetX!B22 will send you to the 22 row of
column B on SheetX. However, I want to make a formula
that will refer to another cell on the same page for the
name of the sheet to reference. How do I do this?
 
Chris,

Not sure of your question, but isn't it....

=SheetX!A1 and replace A1 with the cell of interest.

In general....it is SheetName then ! followed by the cell address. If the
sheet name has spaces or other punctuation, you might have to enclose it in
single apostrophes.

That is,
='Sheet X'!A1

If you are referencing a cell on the same page you are working on, then you
can drop the sheet name.

If you are on SheetX and you want to reference A5, then it is just =A5.

Hope that helps.

Regards,
Kevin
 
Actually I was wanting a way to make the Sheet1 part of
Sheet1:A1 a reference to another cell that would contain
data typed in by the user. Therefore, someone could type
in the sheet name in one cell and the cell that I am
attempting to write would change accordingly.
 
Actually I was wanting a way to make the Sheet1 part of
Sheet1:A1 a reference to another cell that would contain
data typed in by the user. Therefore, someone could type
in the sheet name in one cell and the cell that I am
attempting to write would change accordingly.
Click to expand...

=INDIRECT("'"&B12&"'!"&CELL("Address",B22))

would be most compact and flexible.
 
Thank you - this works great.
-----Original Message-----
...

=INDIRECT("'"&B12&"'!"&CELL("Address",B22))

would be most compact and flexible.

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.
.
Click to expand...
 
Back
Top