Hi everyone,
I'm new here so hoping I post this question correctly and not redundant. I have a sheet where in Column A are names of clients and Column B is the company name the client works for. I get weekly commission reports where the vendors sent me the clients who used their service. My job is to find out which company used the service (Column B) given the clients name (Column A) provided by the vendors. A vlookup chart has worked well until I ran into the issue of a duplicate in the clients name. For example, below is an example chart. There is a John Smith who works for ABC Inc and also another John Smith who works for XYZ LLC. When I do a vlookup, Excel comes back with only the first match (in this case John Smith who works for ABC Inc). Is there an easy formula I can use to somehow get 2 results of ABC Inc and XYZ LLC? Thanks in advance for any input!!!
<tbody>
</tbody>
I'm new here so hoping I post this question correctly and not redundant. I have a sheet where in Column A are names of clients and Column B is the company name the client works for. I get weekly commission reports where the vendors sent me the clients who used their service. My job is to find out which company used the service (Column B) given the clients name (Column A) provided by the vendors. A vlookup chart has worked well until I ran into the issue of a duplicate in the clients name. For example, below is an example chart. There is a John Smith who works for ABC Inc and also another John Smith who works for XYZ LLC. When I do a vlookup, Excel comes back with only the first match (in this case John Smith who works for ABC Inc). Is there an easy formula I can use to somehow get 2 results of ABC Inc and XYZ LLC? Thanks in advance for any input!!!
Client Name | Company |
John Smith | ABC Inc |
John Smith | XYZ LLC |
John Smith | ABC Inc |
=VLOOKUP(A6,A2:B3,2,FALSE) formula used |
<tbody>
</tbody>