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 s
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 tex
in cells A1:A60 to go. Each cell has a unique symbol. Here's th
formula.

=RediLINK|'L1'!'SYM;Vol

 

[Don Guillett]

have a look in the help index for INDIRECT

 

[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