#partial match

Tutorial: Vlookup and the Wildcard Characters (* and ?) for partial matches

There are two wildcard characters in Excel:

an asterisk (*) which matches one or more characters, and

a question mark (?) matches a single character.

To use the asterisk character, we’ll use student names and numbers as a worked example.

In the first case (Cell B4 below), we’ll show that a standard vlookup can be used and the asterisk (*) can be used in the SearchFor cell B4

In the second case,…