NotSoSmartGuy Posted February 9, 2009 Share Posted February 9, 2009 Hi, I'm having a problem w/ excel programming. The following code ... =STOCKLINK|'L1'!'PFE;lp' ----------> gets the price stock stock PFE. what I want to do is type in a stock symbol say in cell A2, and be able to reference it in the formula like... =STOCKILINK|'L1'!'A1;lp' , however excel thinks it is looking up stock symbol "A1", but I want it to look up the stock in cell A1. Thanks Link to comment Share on other sites More sharing options...
0 Kami- Posted February 9, 2009 Share Posted February 9, 2009 Attach the workbook? Link to comment Share on other sites More sharing options...
0 NotSoSmartGuy Posted February 9, 2009 Author Share Posted February 9, 2009 Hmmmm can't really do that, would you have a clue to what might work? Link to comment Share on other sites More sharing options...
0 Kami- Posted February 9, 2009 Share Posted February 9, 2009 Not without seeing something to work with no... unfortunatly, my crystal ball is broken :( Link to comment Share on other sites More sharing options...
0 JamesCherrill Posted February 10, 2009 Share Posted February 10, 2009 If you can't share the whole workbook, how about the exact whole formula that's a problem? You should be able to do what you say by concatenating the fixed strings with the cell reference - basically you need the A1 to be outside the quotes, not inside them. Link to comment Share on other sites More sharing options...
0 Bookieass Posted February 11, 2009 Share Posted February 11, 2009 If you can't share the whole workbook, how about the exact whole formula that's a problem? You should be able to do what you say by concatenating the fixed strings with the cell reference - basically you need the A1 to be outside the quotes, not inside them. +1 Link to comment Share on other sites More sharing options...
Question
NotSoSmartGuy
Hi,
I'm having a problem w/ excel programming.
The following code ... =STOCKLINK|'L1'!'PFE;lp' ----------> gets the price stock stock PFE.
what I want to do is type in a stock symbol say in cell A2, and be able to reference it in the formula like...
=STOCKILINK|'L1'!'A1;lp' , however excel thinks it is looking up stock symbol "A1", but I want it to look up the stock in cell A1.
Thanks
Link to comment
Share on other sites
5 answers to this question
Recommended Posts