I am using the following solution:
=IF(ISNUMBER(FIND("GRB2",B9,1))=TRUE,"FLS2",IF(ISNUMBER(FIND("GRB",B9,1))=TRUE,"FLS",IF(ISNUMBER(FIND("#billing",B9,1))=TRUE,"#billing","None")))
This is looking at a cell where I have concatenated the value(s) of 10 columns (V-AE). From that grouping I want to identify and pull out the terms above. However, it is only pulling one of the terms; I need all matched terms, eg, GRB2, GBR, #payment ...
Net, I need a way to pull all the matched terms. Thanks for the help.
=IF(ISNUMBER(FIND("GRB2",B9,1))=TRUE,"FLS2",IF(ISNUMBER(FIND("GRB",B9,1))=TRUE,"FLS",IF(ISNUMBER(FIND("#billing",B9,1))=TRUE,"#billing","None")))
This is looking at a cell where I have concatenated the value(s) of 10 columns (V-AE). From that grouping I want to identify and pull out the terms above. However, it is only pulling one of the terms; I need all matched terms, eg, GRB2, GBR, #payment ...
Net, I need a way to pull all the matched terms. Thanks for the help.
