reporting_95
New Member
- Joined
- May 7, 2019
- Messages
- 30
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hello,
I have two worksheets with client id and names, but one of them has missing client data. Sheet A has complete client ID and full name. Sheet B has client first names and no IDs. Also, there are multiple clients in both sheets with the same FIRST name, but different client IDs which makes it difficult to match. What I am looking to do is fill in the correct missing data in sheet B, specifically the client ID. I tried using a vlookup but that only works with if sheet B has the client full name. I also tried vlookup with just the first name, but that would label all clients with the same name in sheet B wit the same client ID, and that would be incorrect. I will post an example below.
Sheet A
Sheet B
Essentially, sheet B should have the correct client ID next to the correct client name. I think I'm missing a field of criteria, but please let me know if there is more information needed. Thanks!
I have two worksheets with client id and names, but one of them has missing client data. Sheet A has complete client ID and full name. Sheet B has client first names and no IDs. Also, there are multiple clients in both sheets with the same FIRST name, but different client IDs which makes it difficult to match. What I am looking to do is fill in the correct missing data in sheet B, specifically the client ID. I tried using a vlookup but that only works with if sheet B has the client full name. I also tried vlookup with just the first name, but that would label all clients with the same name in sheet B wit the same client ID, and that would be incorrect. I will post an example below.
Sheet A
Book4 | ||||
---|---|---|---|---|
A | B | |||
1 | Client ID | Name | ||
2 | 40921 | Bill Withers | ||
3 | 17664 | Ethel Mertz | ||
4 | 40754 | Bobby Simmons | ||
5 | 74851 | Bobby Flay | ||
6 | 79481 | Chris Tucks | ||
7 | 98540 | Jamie Dimon | ||
8 | 99788 | Mike Piazza | ||
9 | 24787 | Tommy John | ||
10 | 52178 | Jamie Vazques | ||
11 | 77485 | Victoria Johnson | ||
12 | 54881 | Victora Plate | ||
13 | 85103 | Victoria McLean | ||
14 | 88475 | Daniel Lewis | ||
15 | 87412 | Daniel Murphy | ||
16 | 65241 | MikeTyson | ||
A |
Sheet B
Book4 | ||||
---|---|---|---|---|
A | B | |||
1 | Client ID | Name | ||
2 | 40921 | Bill Withers | ||
3 | Bill | |||
4 | Bill | |||
5 | 17664 | Ethel Mertz | ||
6 | 40754 | Bobby Simmons | ||
7 | Bobby | |||
8 | Bobby | |||
9 | Bobby | |||
10 | 98540 | Jamie Dimon | ||
11 | Jaime | |||
12 | Jaime | |||
13 | 77485 | Victoria Johnson | ||
14 | Vicki | |||
15 | Victoria | |||
16 | Victoria | |||
17 | 99788 | Mike Piazza | ||
18 | Michael P | |||
19 | Mike | |||
20 | Daniel | |||
21 | Daniel | |||
22 | Mike | |||
B |
Essentially, sheet B should have the correct client ID next to the correct client name. I think I'm missing a field of criteria, but please let me know if there is more information needed. Thanks!