Hello, I am attempting to look up only the sales team names from 2 columns of employee names. I will be using a list of Sales Team employee ID numbers as the look up value to identify the sales team. In column 1 is the first and last name separated by a space. In column 2 there are multiple employee names in each cell separated by a comma. In column 3 there is a list of employee ID numbers for the sales team, this list has multiple numbers in each column separated by a comma. I want to return all sales team names, whether it is one name or multiple separated by a comma from column 1 & 2. Please see example below.
I attempted to use a match index function but I can't seem to apply the index to 2 columns. The look up value I also with in a line of text separated by commas. Any help would be much appreciated. Please let me know if not clear.
I attempted to use a match index function but I can't seem to apply the index to 2 columns. The look up value I also with in a line of text separated by commas. Any help would be much appreciated. Please let me know if not clear.
