Re: Search for multiple words

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Domenic (Domenic.1ejfen_at_excelforum-nospam.com)
Date: 10/22/04 

Date: Fri, 22 Oct 2004 12:04:39 -0500

I'm not sure this is what you're looking for, but see if this helps...

B1, copied down:

=CHOOSE(MATCH(TRUE,ISNUMBER(SEARCH($D$1:$D$2,A1)),0),"Paul","Marc")

..entered using CONTROL+SHIFT+ENTER, where D1:D2 contain the words for
which you're searching. You'll be able to expand the list of words for
which to search. Make sure you make the necessary adjustments to the
formula. For example, you'll have to change the range (D1:D2) and
you'll have to add the values/names...
Choose(...,"Paul","Marc",etc...)

Hope this helps!

titoto Wrote:
> I need a formula which would enable me to search for more than 7 words
> ( I
> have at least 20 word) and when 1 of the word is found to display that
> word.
> In any given cell will contain 1 of the words needed.
>
> 'IF', 'Countif' function allow no more than 7 words.Any idea
> eg
> A B
> hdfjjkduo...PAUL...iuepoipwp search PAUL or MARC or so on-
> Result
> = PAUL
>
>
> hhjhwoujiowqu...MARC...ioo Result = MARC
> so on so on 

-- 
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10785
View this thread: http://www.excelforum.com/showthread.php?threadid=271597

Relevant Pages

  • Re: multiple inputs, multipul outputs (part 2)
    ... paul Wrote: ... that the 115/12 and 225/12 actually just refferred to another cell ... rjmckay's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16880 ...
    (microsoft.public.excel.misc)
  • Re: make the cell hyperlink to any name within it
    ... Create a table with two columns, column A would be a name, Paul etc, ... column B would contain the equivalent email address from column A ... Highlight the cell you want say C2 and enter this formula ... Special-K's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7470 ...
    (microsoft.public.excel.newusers)
  • Re: make the cell hyperlink to any name within it
    ... Create a table with two columns, column A would be a name, Paul etc, ... column B would contain the equivalent email address from column A ... Highlight the cell you want say C2 and enter this formula ... Special-K's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7470 ...
    (microsoft.public.excel.newusers)
  • Re: Gap between Headings and Start of Output
    ... Paul: I want to make sure I solvig the right problem. ... The abbove line is moving the active cell down the worksheet. ... My original code is ... ... Const MaxDist As Integer = 279 ...
    (microsoft.public.excel.programming)
  • RE: How do I setup a drop down box for using addresses
    ... Thank You Paul for your assistance. ... customers,click the red tab again,and then click the tab cell link and click ... a description next to it say customer cell link. ... somewhere on the sheet to deselect the combo box.When you click on the combo ...
    (microsoft.public.excel.worksheet.functions)