Is it possible to use the Smart Tag feature in Excel 2007 to reference one cell that has a stock ticker in it and then:
1. Populate a cell with the company name
2. Populate a different cell with the closing price of the stock?

ie,
Cell A2 has the Ticker symbol
Cell A3 will get the Company name
Call A4 will get the closing price

It seems that you have to accept a lot more information when using this feature.

Any ideas?

Thank you,
Barney