Excel: How to search for a string in a range of cells?

Solved
Gnagnagna -  
 Xavier -
Hello;

I would like to search for a string in a range of cells and have the content of the first cell that matches the criterion returned to me.

For example:
I am looking for "lolo"
In a range of cells (example: A1-A10)
The first cell that meets the criterion is C1 which contains "hello my name is lolo"
Therefore, the cell with the search function returns: "hello my name is lolo"

I can't find how to do that.

3 answers

  1. via55 Posted messages 14396 Registration date   Status Member Last intervention   2 759
     
    Hello

    =INDEX(A1:A10;MATCH("*" &"lolo" &"*";A1:A10;0);)

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    1
    1. Gnagnagna
       
      It works :D ... but not horizontally :(
      0
    2. Xavier
       

      Thank you, Via !!

      For me, it's working vertically, and I've been struggling with it for days.

      Long live the Net and long live Via! :-)

      0