View original (French)

Search for a word in a cell

Solved
nonossov Posted messages 638 Status Member -  
 Sachex -
Hello my friends,

I need your help to find a word in a cell and give its corresponding value; for example, cell A1 contains the words Smart vision technology, and cell B1 contains 100,

I want to know the formula I can use to search for the word vision in A1 and get the corresponding value.

For your information, I used this formula to find the corresponding value of a single word; now I need to find a word in a phrase, for example.

=+VLOOKUP(A1,Sheet2!$A:$B,2,0)

Thank you in advance, my friends!

Configuration: Windows XP / Chrome 48.4.2564.88

2 answers

  1.
    Unombre Posted messages 41 Status Member 16
     
    Hello,

    Can you do this:
    =IF(COUNTIF(A1,"*vision*"),B1,"")
    6
    1. nonossov Posted messages 638 Status Member
       
      Hello Sir,
      Yes, this formula can be useful to me, but can we search for a word without writing it in the formula? For example, in the same formula:

      =IF(COUNTIF(A1;"A2");B1;"")
      can we search for the word written in A2 instead of writing it in the formula??

      Thank you very much.
      0
      1. Unombre Posted messages 41 Status Member 16 > nonossov Posted messages 638 Status Member
         
        Sure, it will be:

        =IF(ISERROR(SEARCH(A2,A1));"";B1)

        It looks for A2 in A1; if yes, then B1, otherwise nothing.

        There are certainly other methods, maybe this one will suit you better.
        1
    2. nonossov Posted messages 638 Status Member
       
      Thank you so much Mr. Unombre!!!
      0
    3. Sachex
       

      Thank you!! The use of stars is excellent!!

      0