Forum Discussion
Lucascobar
Aug 24, 2021Copper Contributor
HOW TO: "If cell contains specific text then return specific text"
If I have a list of things, and I want to have the return from another list if it contains certain keywords. In the appendix of file, the column A is the original list, and I want to have it retu...
- Aug 24, 2021
=FILTER($F$3:$F$5,ISNUMBER(SEARCH($E$3:$E$5,A2)))
SergeiBaklan
Aug 24, 2021Diamond Contributor
Lucascobar
Aug 25, 2021Copper Contributor
Thanks for the quick solution!!