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
- How to find specific words on a page - Guide
- Count if cell contains number - Excel Forum
- Based on the cell values in cells b77 ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel: If Date =, then enter a 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