2
I have a problem, I have a problem spreadsheet. Currently I can do the search by name, but I wanted to type only part of the name, for example, instead of typing "Raquel", type "Ra" he already bring me Raquel, Rafael, Raimundo, etc...
With this formula =PROCV("*"&B8&"*";B11:F100;2;FALSO), for example, I can pick up part of the text.
What I need, and I’m not getting it, is to unite the two functions.
If anyone can help me, I’d appreciate it.
In another forum they managed to understand my question...if someone understood and interested in discovering the solution, follows the formula: =SE($G$5="";"";SE(LINS($H$5:$H5)>CONT.SE($A$5:$A$15;""&$G$5&"");"";Index($B$5:$B$15;MINOR(IF(NOT(ES(FIND(""&$G$5&"";$A$5:$A$15));LIN($B$5:$B$15)-LIN($B$4));LINS($H$5:$H5))))(press CTRL + SHIFT + ENTER to make matrix)
– netovgs