google sheets how to allow partial matches in vlookup
# Basic syntax:
=VLOOKUP("search_string*", search_range, index)
=VLOOKUP(search_key&"*", search_range, index)
# Where:
# - search_string/key is the value to search for (can be str, int, etc)
# - search_range is the range to consider for the search
# - index is the column value to return when a match is found (starting
# from where the search_range is defined
# For partial matches, * acts as a wildcard for anything and ? acts as
# a wildcard for a single character. The & is used to concatenate the
# wildcard to the search_key if it isn't a string.