Data tab: I have some data with a column called provider which contains multiple provider names separated by a comma. (Some of these names may have a comma within the provider name (e.g. ABC HOME, INC, BEES, INC.)
Pivot tab: I have a pivot table showing me provider's names in a column
I need to flag a new column in my Data tab that says whether or not there is a match between my comma-separated values of provider names to the Pivot tab's pivot table provider name list...
almost like this formula (which is not working): IF(ISNUMBER(SEARCH(Pivot_tab'!$A$5:$A$70,Data_tab!AX2)),"yes""no")
Pivot tab: I have a pivot table showing me provider's names in a column
I need to flag a new column in my Data tab that says whether or not there is a match between my comma-separated values of provider names to the Pivot tab's pivot table provider name list...
almost like this formula (which is not working): IF(ISNUMBER(SEARCH(Pivot_tab'!$A$5:$A$70,Data_tab!AX2)),"yes""no")