Thread
:
Referencing text in a cell in a formula
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Referencing text in a cell in a formula
have a look in the help index for INDIRECT
--
Don Guillett
SalesAid Software
"jimbob" wrote in
message ...
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
Reply With Quote