I have one problem, I have a spreadsheet . Now I can do the search by name, but I wanted to type only part of the name, for example, instead of typing "Raquel", I type "Ra" he already bring me Raquel, Rafael, Raimundo, etc ...
With this formula =PROCV("*"&B8&"*";B11:F100;2;FALSO) , for example, I can get some of the text.
What I need, and I can not do, is to unite the two functions.
If someone can help me, thank you.