Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing text in a cell in a formula
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing text in a cell in a formula
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing text in a cell in a formula
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 "jimbob" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Strange Formating problem with text and formula in same cell | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
GET.CELL | Excel Worksheet Functions |