| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing text against a text table for yes no result
I have a Column "A" containing 7 company names.
I have Column "C" of 3 words I need in Column "B" to know the following formula. Does "A1:A7" contain any of the words in C1:C3, and return the result "Yes" or "NO" in "B1:B7" The contain function means "that the words in C1:C3 can be found in any (case) and anywhere in the string of Cell. Example A1 B1 C1 Al's Video Yes Video Guitar shop No Audio LA Video Yes AV NYC elec No Miami Audio Yes AV Audio Yes LA Audio CA Yes Thanks in advance - Nigel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Text | Excel Worksheet Functions | |||
| comparing two text ranges | Excel Discussion (Misc queries) | |||
| Please help ... comparing text | Excel Worksheet Functions | |||
| Comparing Two Columns of Text | Excel Discussion (Misc queries) | |||
| Comparing text fields | Excel Worksheet Functions | |||
Threaded Mode
