Resolve partial text matching in Excel by combining INDEX, MATCH, and SEARCH to dynamically return values from a list based on substring patterns.