TheVLOOKUP functionsupportswildcards, which makes it possible to perform a partial match on a lookup value.
Placing the wildcard at the end results in a “begins with” match.
This will cause VLOOKUP to match the first entry in column B that begins with “Aya.”
Note: inExcel 365, theFILTER functioncan displayallmatches at the same time.
FILTER function
InExcel 365, the newFILTER functionprovides amore powerful way to filter on partial matches.
