# How To Use Vlookup Wildcard To Implement Partial Match In Excel

The excel VLOOKUP function provides a partial match feature. In this feature, you can implement a fuzzy search using wildcards. This article will tell you how to use wildcards to implement partial matches in the excel VLOOKUP function.

### 1. How To Use Vlookup Wildcard To Implement Partial Match In Excel.

1. You can use 3 wildcards (*, ?, and ~) in the excel VLOOKUP function to implement a partial match.
2. The asterisk wildcard ( * ) can match zero or multiple characters when used in the VLOOKUP function.
3. The question mark wildcard ( ? ) can match one character in the VLOOKUP function.
4. The tilde mark wildcard ( ~ ) can be used to escape the above 2 wildcard characters, which means when you want to match the wildcard character * or ? in the cell value, you can add the ~ character before it.
5. When you want to implement a partial match using the excel VLOOKUP function, you must pass FALSE to the fourth parameter of the VLOOKUP function.
6. The excel VLOOKUP function will return the first matched cell value.

### 2. Use Excel Vlookup Wildcard To Implement Partial Match Examples.

1. Below are the example data cells.
 A B C 1 ID Product Price 2 1 iPhone1 1100 3 2 iPhone2 1000 4 3 iPhone3 900 5 4 iPa*d 900 6 5 Macbook Pro 1500 7 6 Macbook Air 1800 8 7 Mac?Mini 1000 9 8 Apple Watch 800 10 9 Apple & iPhone 3000
2. The formula =VLOOKUP(“Mac*”, B1:C10,1, FALSE) will return the textÂ Macbook Pro whichÂ is the cell B6‘s value.
3. The formula =VLOOKUP(“?Phone?”, B1:C10,1, FALSE) will return the text iPhone1 which is the cell B2‘s value.
4. The formula =VLOOKUP(“iPa~**”, B1:C10,1, FALSE) will return the text iPa*d which is the cell B5‘s value. The first parameter in the VLOOKUP function is “iPa~**”, the ~* part will match the character * in the cell value.
5. The formula =VLOOKUP(“Mac~?*”, B1:C10,1, FALSE) will return the text Mac?MiniÂ which is the cell B8‘s value. The first parameter in the VLOOKUP function is “Mac~?*”, the partÂ ~? will match the question mark character ( ? ) in the text.

Reference

We donâ€™t spam!

We donâ€™t spam!