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