Check out example codes for "google sheets how to allow partial matches in vlookup". It will help you in understanding the concepts better.

Code Example 1

# 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.

Learn ReactJs, React Native from akashmittal.com