Matching Error

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).