Hi, I am posting this request since I am not able to find a solution to what I am looking for. I attached the sample file to be used as reference.
I have 3 tabs:
"Data" contains a list of Style codes in column C and from column E to P(it may vary and become longer) I have as a header a feature name and in the cells below, identified with TRUE/FALSE, we can see if that feature is available for the style code
"Config list": here we have the current list of features(could be longer). the feature name is in column A and in Column B there is the Feature code.
"Import_Data": inside this tab I have the style code in column A, please note that here the style code is 3 digits longer than the one in sheet "Data". in Column AS I have the field Technologies. the result expected is to lookup the first 6 digits of the material codes in column A, find them in sheet "Data" and return the codes of the features marked with TRUE(split by a comma if multiple values are found) or left blank if no TRUE value is found. in column AS I have put the expected result. the number of material codes in column A can vary.
hope the description above is clear enough! thanks in advance for the support!
I have 3 tabs:
"Data" contains a list of Style codes in column C and from column E to P(it may vary and become longer) I have as a header a feature name and in the cells below, identified with TRUE/FALSE, we can see if that feature is available for the style code
"Config list": here we have the current list of features(could be longer). the feature name is in column A and in Column B there is the Feature code.
"Import_Data": inside this tab I have the style code in column A, please note that here the style code is 3 digits longer than the one in sheet "Data". in Column AS I have the field Technologies. the result expected is to lookup the first 6 digits of the material codes in column A, find them in sheet "Data" and return the codes of the features marked with TRUE(split by a comma if multiple values are found) or left blank if no TRUE value is found. in column AS I have put the expected result. the number of material codes in column A can vary.
hope the description above is clear enough! thanks in advance for the support!