I
Igneshwara reddy
Hi,
I have to find in one cell, whether any of three words matches. If it
matches, I need to get results as
If it finds word "Spot" in the cell, the answer should reflect as "4", if it
find word "Renewal API" the it should reflect answer as "Renewals" and if
none of the above both words are found it should reflect answers as "others".
Let me know how can I get the desired results.
Regards,
Igneshwara Reddy
I have to find in one cell, whether any of three words matches. If it
matches, I need to get results as
If it finds word "Spot" in the cell, the answer should reflect as "4", if it
find word "Renewal API" the it should reflect answer as "Renewals" and if
none of the above both words are found it should reflect answers as "others".
Let me know how can I get the desired results.
Regards,
Igneshwara Reddy