Forum Discussion
Group with Name and use Keywords
In Excel 365 you would use ISNUMBER/SEARCH to determine whether the word 'Stahl' is present and FILTER to limit the list to the matched items. From you choice of functions, I assume you are using an older version of Excel.
Hi PeterBartholomew1 ,
I have a sheet with list of parts, it's material name (some grade/kind of metal or plastic) along with its weight (sheet 1).
A List is defined with different material names classified into "Metals" and "Plastics" Names in Excel (sheet 2).
I am summing the weights of Material from sheet 1 based on the comparison made with "Metals" and "Plastics" list in sheet 2 and the sum is displayed like this
Here sheet 1 is the input I get and the material names are not standardized here and aslo I cannot do the changes though there are several naming conventions like Stahl, Stahl DC01,.... I can only control the Names list "Metals" and "Plastics" where I have added manually the list of materials. If there is a new additional material for example Stahl_XX_YY I need to add this into the "Metals" list and which would be a difficult task to check among the several input lines.
So I want to say in my Names list, if *Stahl* keyword is in sheet 1 Material column then add into metals.