Matching Error

[Guitarist]

Hi All!

I am having an issue matching a name from one column to another column on another sheet. Specifically, the license name next to the name. One sheet has a name with data. I know how to find that matched name on another sheet, but want to also find the license that is next to it and matches. My steps taken are below and created a fake report with 4 rows to show as an example. Thank you!

The below steps were taken to achieve the results that are unfortunately incorrect. The issue comes when matching an employee name to its license name a couple of columns to its right in sheet 1 of the expiring report. I have attached both without edits. The screenshot below is what I receive when following the steps I thought would be able to achieve what we needed.

Steps Followed:

1. In C2, place the following formula: =MATCH("*"&B2&"*",Sheet1!A:A, 0). Drag down so that the formula applies to each row.
2. In D2, place the following formula: =IF(MATCH("*"&B2&"*", Sheet1!A:A, 0), Sheet1!B:B, 0). Drag down accordingly.
3. The results should show the row and license name for that employee. (This unfortunately is where we receive the error. The top one, LisaLisa, shows Basic Life in column D, but should show 7th Edition NRP Provider).

[Glenn Kennedy]

Please post a wokbook after Step 2. There are no errors in your posted sheet and it all looks overly complicated. Let's see what you start with and we can go from there.

[Sam Capricci]

You've given us a lot of information about your process that does not pertain to your attached workbook, for example, nothing in cell U2 in either sheet nor any #N/A outputs.
Next, in your user profile you list your MS version as Tennessee which is not a MS version. The reason we ask for a version is because some formulas will work in newer versions but will not work in older versions.
For example, depending on your version i would recommend you look into downloading the fuzzy lookup application available from Microsoft for excel that allows imperfect matching here... https://www.microsoft.com/en-us/down....aspx?id=15011
So please consider these recommendations about your attachment and profile.

[Guitarist]

Sorry about that! I have edited the sheet and will edit my primary post

[Glenn Kennedy]

Based on a rather limited sample...


=VLOOKUP(B2&"*",Sheet1!A:B,2,FALSE) in d2, copied down.