If cell contains a word from a word bank, then return value
Closed
JL
-
3 Oct 2016 à 10:56
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 3 Oct 2016 à 11:30
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 3 Oct 2016 à 11:30
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
3 Oct 2016 à 11:30
3 Oct 2016 à 11:30
Jl, Good afternoon.
Try to use:
A1:A30 --> Words to looking for
=IF(COUNTIF(A1:A30, D2), "TRUE", "FALSE")
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
A1:A30 --> Words to looking for
=IF(COUNTIF(A1:A30, D2), "TRUE", "FALSE")
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão