Company Names
In this video we use IF, IFERROR, MATCH, INDEX, and Text functions to find a company’s abbreviation from a list of abbreviations and then highlight the abbreviation within a company’s name.
These are the before and after files needed to follow along to this video: