If you just want to find which name is partial match the given name, you also can use this formula =INDEX($E$2:$E$14,MATCH($K$1&"*",E2:E14,0)). In the formula, K1 is the cell containing the partial string, E1:H14 is the data range, 4 indicates to lookup value in the Forth column of the range. Select another cell which you will place the look up value at, and enter this formula =VLOOKUP($K$1&"*",$E$1:$H$14,4,FALSE), press Enter key to get to value. Select a blank cell to enter the partial string that you want to look up. Here I have some formulas to help you lookup partial string match in Excel.ġ. How to lookup partial string match in Excel?įor example, there is a range of data, and column E is the students’ name list, column F and G are the class and grade of the students, and column H is the ranking of the students’ scores, now you have a given name “Jack” which is the partial string of “Jacky”, how can you quickly lookup partial string match and return the ranking of the “Jacky” as below screenshot shown.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |