| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help!
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please Help!
Try this:
=A1 & "!B28" Regards, Paul -- "Brian" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please Help!
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" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please 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. "Brian" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please Help!
Contents of b1 is
="="&A1&"!b28" Brian wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please Help!
Brillant! thank you.
"Max" wrote: 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" wrote: 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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please Help!
Thank you for you help.
"KIM W" wrote: 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. "Brian" wrote: 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please Help!
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 --- "Brian" wrote: Brilliant! thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
