Partial Text Match with Index/Match

I'm trying to do a partial text lookup with Index and Match but it's only returning the value when there's an exact match. Here is the rundown:

I have a list of transaction line items and each line item begins with a users ID (e.g. CDOLEZAL-TEAM LUNCH LA). I have a separate sheet with Column A being the users' full name and Column B with their corresponding user ID. What I want to accomplish is to do an INDEX/MATCH lookup on the user ID in the line item and return the user's full name. Here is what I currently have:

{=INDEX(NTIDs!$A$2:$A$181,MATCH(Sheet8!A2"*"&,NTIDs!$B$2:$B$181,0))}

Sample below:

Name & ID Sheet
Attachment 616863

Transaction Data Sheet
Attachment 616865
*Essentially want to do the INDEX/MATCH under the Owner column

The first problem I see is that the line items do not actually begin with the userid. There is no way to take CDOLEZAL and match it to CDole1, or match HArtiaga to HArti20.

Hello & Welcome to the Forum,

A picture does not really do anyone much help as we can't test with it.

You could use the Fuzzy Matching macro from here. Post #2

You would then apply it to your sheet as =FuzzyVLookup(A2,NTIDs!$A$2:$B$181,2,,1) in cell D2 and down

Try this...

Change the part in red...

=FuzzyVLookup(A2,'Name.ID List'!$A$2:$B$181,1,,1)

You are very welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.