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.
