Forum Discussion
Helsinkiniano
Mar 14, 2024Copper Contributor
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...
OliverScheurich
Mar 14, 2024Gold Contributor
=IF(ISNUMBER(SEARCH(CH$2, $CG3)), "Yes", "No")
This formula dynamically references the type of animal in the column header.