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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
separating out data in columns 2
dropdown unhide sheet 3
Lookup 14
Excel - Wich Function should I use? 1
Reference Formula 2
if the date 1
If, Or, and 5

Top