Referencing text in a cell in a formula

[jimbob]

I have a formula (see below) that I want to be able to drag and copy so that the text in cells A1:A60 copies automatically into the formula. These are stock symbols. Where you see "SYM" is where I need the text in cells A1:A60 to go. Each cell has a unique symbol. Here's the formula.

=RediLINK|'L1'!'SYM;Vol'

[Don Guillett]

have a look in the help index for INDIRECT

--
Don Guillett
SalesAid Software
[email protected]
"jimbob" <[email protected]> wrote in
message news:[email protected]...
>
> I have a formula (see below) that I want to be able to drag and copy so
> that the text in cells A1:A60 copies automatically into the formula.
> These are stock symbols. Where you see "SYM" is where I need the text
> in cells A1:A60 to go. Each cell has a unique symbol. Here's the
> formula.
>
> =RediLINK|'L1'!'SYM;Vol'
>
>
> --
> jimbob
> ------------------------------------------------------------------------
> jimbob's Profile:
> http://www.excelforum.com/member.php...o&userid=29107
> View this thread: http://www.excelforum.com/showthread...hreadid=516920
>

[jimbob]

I don't think that applies. I am not looking for indirect reference to another cell. I simply want the text in cell A1 to be placed in the formula. Cells A1 thru A60 contain stock symbols. I want to enter the formula once and then be able to copy it down and have the field "SYM" automatically populate with whatever symbol is in the corresponding A col. I would think this would be pretty easy, but I can't find any help in the documentation. Thanks for your help.

[Don Guillett]

if I have sheet11 typed into cell a10 and use
=INDIRECT(A10&"!A1")
I will get the same as =sheet11!a1
--
Don Guillett
SalesAid Software
[email protected]
"jimbob" <[email protected]> wrote in
message news:[email protected]...
>
> I don't think that applies. I am not looking for indirect reference to
> another cell. I simply want the text in cell A1 to be placed in the
> formula. Cells A1 thru A60 contain stock symbols. I want to enter the
> formula once and then be able to copy it down and have the field "SYM"
> automatically populate with whatever symbol is in the corresponding A
> col. I would think this would be pretty easy, but I can't find any help
> in the documentation. Thanks for your help.
>
>
> --
> jimbob
> ------------------------------------------------------------------------
> jimbob's Profile:
> http://www.excelforum.com/member.php...o&userid=29107
> View this thread: http://www.excelforum.com/showthread...hreadid=516920
>