How to change full name of company via just company Ticker Symbol

[usama5788]

Hi,

Can you please see attachment. I have a web query in sheet 2. Where it pulls off the wall street journal page with updated real time particular company information. I have a Summary sheet where I have VLOOKUP for the information in Sheet 2.

As you can see in F2 in Summary sheet I have the Ticker name of the company. And F2 is linked to cell A2. I am trying to find a way in which I can have full company name in A2. For example FB=Facebook. I want to be able to do that with any company. For example if I were to change ticker symbol to “GM” in cell F2, I want A2 to automatically change "General Motors".

[oeldere]

with a sheet with the full names.

After that a vlookup

a2 =VLookup(SUMMARY!F2,data!$A$1:$B$10,2,0)

See the attached file.

[usama5788]

Hi,

I think my question is regard to my "Summary sheet" and I want the result via only Sheet 2. I cannot add another sheet as a master sheet. I was hoping to get a formula in which Summary Sheet A1 can lookup in Sheet 2 cell A21 and pickup only the name of the ticker symbol. Hopefully that explains is better

Capture.JPG