google sheets how to allow partial matches in vlookup

1# Basic syntax:
2=VLOOKUP("search_string*", search_range, index)
3=VLOOKUP(search_key&"*", search_range, index)
4
5# Where:
6#	- search_string/key is the value to search for (can be str, int, etc)
7#	- search_range is the range to consider for the search
8#	- index is the column value to return when a match is found (starting
9#		from where the search_range is defined
10
11# For partial matches, * acts as a wildcard for anything and ? acts as
12#	a wildcard for a single character. The & is used to concatenate the
13#	wildcard to the search_key if it isn't a string. 
14