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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing text against a text table for yes no result
Whoever you are - Thanks you so much it worked great - Nigel
"RagDyer" wrote: Try this in B1: =IF(SUMPRODUCT(--(ISNUMBER(SEARCH($C$1:$C$3,A1)))),"Yes","No") And copy down as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Nigel Toates" <Nigel wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing text against a text table for yes no result
Since I sign my posts as RD, I guess I'm RD.<bg
You're welcome, and appreciate the feed-back. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Nigel Toates" wrote in message ... Whoever you are - Thanks you so much it worked great - Nigel "RagDyer" wrote: Try this in B1: =IF(SUMPRODUCT(--(ISNUMBER(SEARCH($C$1:$C$3,A1)))),"Yes","No") And copy down as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Nigel Toates" <Nigel wrote in message ... 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 |
Reply |
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 |