Please Help!

[Brian]

cell a1 has the name Jones in it.

in b1 I would like to have the following formula: =a1 (plus add the
following) !b28
so that the name jones is returned in b1 looking like this: =jones!b28.

I hope I explained my question adequately.
I am a complete novice.

Thank you,
Brian

 

[PCLIVE]

Try this:

=A1 & "!B28"

Regards,
Paul

 

[Max]

Try it like this, using INDIRECT, in say B1: =INDIRECT("'"&A1&"'!B28")
It assumes A1 houses a valid sheetname,
and it returns the contents of B28 in that sheet
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik

 

[KIM W]

In cell B1 enter
=A1&"!b28"

The "&" concatenates things. The quote signs around things make them
literal strings that are displayed exactly as they are within the quotes.

 

[Bob I]

Contents of b1 is
="="&A1&"!b28"

 

[Brian]

Brillant! thank you.

Try it like this, using INDIRECT, in say B1: =INDIRECT("'"&A1&"'!B28")
It assumes A1 houses a valid sheetname,
and it returns the contents of B28 in that sheet
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik

 

[Brian]

Thank you for you help.

In cell B1 enter
=A1&"!b28"

The "&" concatenates things. The quote signs around things make them
literal strings that are displayed exactly as they are within the quotes.

 

[Max]

Welcome. Pl press the YES button (like the one below) in that response.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik