| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compare data - one cell to multiple cells
Hello wise Excel users,
I need to compare a word in a single cell to a group of words. If that word matches any one of the group then I'd like it to return "true". The group of words are currently in a comma delimited text file so I can arrange them however I need to. How can I go about doing this? |
|
#2
|
|||
|
|||
|
Hi,
Assume the word you want to find is in cell A1, and the string of text you want to search within is in cell B1: =IF(ISERROR(FIND(A1,B1,1)),"Not found","Found") Regards, A -- Please rate my response if you found it helpful. Thanks. "srs710" wrote: Hello wise Excel users, I need to compare a word in a single cell to a group of words. If that word matches any one of the group then I'd like it to return "true". The group of words are currently in a comma delimited text file so I can arrange them however I need to. How can I go about doing this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data from multiple cells into one string. | Excel Discussion (Misc queries) | |||
| how do i seprate multi data cell into 2 or more cells | New Users to Excel | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
