Dears,
I want to find if a keyword(s) is available in a excel cell (Either using formulas or data validations)
Please refer the attached file. Worksheet "Data" will have some example data and "Keywords" will have keywords to be searched.
The attached file contains the customer feedbacks on some products purchased via Online Shopping.
Columns A - I is the data which I extracted from the system, Customer Reviews are available in the Column "G" and Review Title in Column "H".
Columns J - V (Highlighted in Yellow) - based on the customer review I will find and update the exact keyword from the keywords sheet. I will update "Nil" if the columns header is not applicable for the respective comments (refer Row No 2).
Is there any way to apply formula to pick the keywords automatically?? Also, I may add new keywords in future so the formula should check the entire keywords available in the "Keywords" sheet. And the formula should check both Reviews (Column G) and Title (Column H) before applying the result.
Many thanks in advance.
Regards,
Vignesh M
I want to find if a keyword(s) is available in a excel cell (Either using formulas or data validations)
Please refer the attached file. Worksheet "Data" will have some example data and "Keywords" will have keywords to be searched.
The attached file contains the customer feedbacks on some products purchased via Online Shopping.
Columns A - I is the data which I extracted from the system, Customer Reviews are available in the Column "G" and Review Title in Column "H".
Columns J - V (Highlighted in Yellow) - based on the customer review I will find and update the exact keyword from the keywords sheet. I will update "Nil" if the columns header is not applicable for the respective comments (refer Row No 2).
Is there any way to apply formula to pick the keywords automatically?? Also, I may add new keywords in future so the formula should check the entire keywords available in the "Keywords" sheet. And the formula should check both Reviews (Column G) and Title (Column H) before applying the result.
Many thanks in advance.
Regards,
Vignesh M