If cell contains a word from a word bank, then return value
Closed
JL
-
Oct 3, 2016 at 10:56 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 3, 2016 at 11:30 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 3, 2016 at 11:30 AM
Related:
- If cell contains specific text
- If cell contains date then return value ✓ - Excel Forum
- How to find specific words on a page - Guide
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 3, 2016 at 11:30 AM
Oct 3, 2016 at 11:30 AM
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