Reference attached file. I need the column called "Category Index" that is located in the tabs labeled "WW" and "NCG" to be populated with the applicable category index number from the "Category Index" tab.
If an Account Name does not appear to have a corresponding category index match then mark the cell yellow. Otherwise populate the cell under the category index column with the appropriate matching number.
I've done the first 9 records in the WW tab as an example. I'm expecting that there will be a significant amount of accounts that will not have corresponding matches.