I'm trying to find a formula that will return me names from a two column list, with three-letter codes in Col A, eg ABC, ABD etc, and the names in Col B, eg Alcoa, IBM etc.
I want to input a list of three-letter codes in another column and get the names automatically with a formula. Any ideas please?