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 not 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.
Bookmarks