Hello,
See document. I have a bunch of company names in tab1 column A. In column C i want the ticker symbol that belongs to the company. Therefore I downloaded tickersymbols with company names from several website and stock exchanges (nasday, nsye, yahoo, amse) While the names of the companies I selected are not written EXACTLY the same as from the databases it won't match with VLOOKUP. Therefore I added in tab1. colum D F H J L N P the same formula to each tab linked and another formula with INDEX to select as much as that possible is. I know that not all of the companies of my column A are listed companies so therefore not every company wil get a symbol ticker.
My goal is to minimize manual handling by using google for looking up symbol ticker and add manual. Is there somebody that could help me with a better formula or way to fix?
with wildcards, index, match search a combination perhaps. or a total other way with not excel help.
Many thanks!