Forum Discussion
F and ISNUMBER functions
Hi, my culumn CG have answers to the question: "Have you experienced any human-wildlife conflict?", and the possible answers are "no", "yes: elephants", "yes, mices", "yes: elephants; mices" or o...
=LET(
animals, {"elephants", "mices"}, IF(ISNUMBER(SEARCH(animals, CG3)), "Yes", "No)
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.