• 0

Excel Programming Help


Question

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

  • 0

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

  • 0
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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.