Please Help!

B

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
 
M

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
 
K

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.
 
B

Brian

Thank you for you help.


KIM W said:
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.
Click to expand...
 
Top