Hi, I have a long list of names of corporations and was wondering if there was a way to look up their symbols in Excel (without going through "Data", "from web" etc.). Being able to go in the opposite direction (converting symbols into corporations' names) would also be very useful. I think I once came across a macro that performed this task, but didn't work when I tried it in MS 2007. Thanks so much! Any help is appreciated!