I have attached an example of a file i am working through. I have a company department hierarchy in rows and a separate list of important departments. I am looking from RIGHT to LEFT for a match to the "important list" and display that separately in yellow. Any help would be much appreciated, thanks.
Bookmarks