Download the feature files here https://www.bluepecantraining.com/how-to-perform-fuzzy-match-or-partial-match-lookups-in-excel/

This video demonstrates how to perform fuzzy or partial match lookups in Excel. There are two scenarios where you might need to use a partial match:

When the lookup value is partial
When the lookup table contains partial strings.

The video covers both scenarios.

In Office 365 we can use XLOOKUP and FILTER to perform fuzzy or partial matches, but in older versions of Excel we have to use VLOOKUP, MATCH and INDEX. The SEARCH and ISNUMBER functions are also used. The video demonstrates how to use all these functions, so no matter what version of Excel you are using you will find a solution here.
------------------------