I have two Excel sheets:
Sheet 1 (Master Sheet):
This contains the full list of users, along with details such as their roles and statuses.
Sheet 2 (Target Sheet):
This contains a smaller, selected list of users, and it also has columns for roles and statuses.
I want to:
Identify users who appear in both the Master Sheet and the Target Sheet.
Match users by name, even if the names are not exactly the same (there may be small spelling or formatting differences).
Once a match is found, extract:
User details from the Master Sheet (e.g., role, status)
User ID and name from the Target Sheet
Output a combined result showing information from both sheets for the matched users.
Example
Master Sheet
| Master ID | Full Name | Role | Status |
| M001 | Brown Nana Nyary | Admin | Active |
| M002 | Sarah Ann Mensah | Editor | Inactive |
| Target ID | Name | Selected | Role | Status |
| T101 | Brown N. Nyary | Yes | Admin | Active |
| T102 | B. A. Mensah | No | Editor | Active |
Expected Output
| Master ID | Target ID | Name(Target) | Name(Master) | Role | Status |
| M001 | T101 | Brown N. Nyary | Brown Nana Nyary | Admin | Active |
Even though the names are not exactly the same, they are treated as a match.
