This will append the asterisk to any value entered in H4, and XLOOKUP will perform a wildcard lookup.
XLOOKUP supports approximate and exact matching, wildcards (* ?)
XLOOKUP wildcard match example
To perform a partial match with XLOOKUP, supply 2 for the match mode argument to allow wildcards. In the example shown, the formula in H7 is: =TRANSPOSE((XLOOKUP(H4,D5:D15,B5:E15,"Not found",2))) which performs a wildcard match with the value in H4 and returns all 4 fields as the result. The TRANSPOSE function is optional and used here only to convert the result from XLOOKUP to a vertical array.
