Comparing two lists in excel, but with a twist!

vidita

New Member
Joined
Mar 28, 2007
Messages
8
Hi,
I am trying to do the following:

There are two sets of supplier lists - A List and B List. I need to compare the two lists. Source A is my master. Source B is a subset of that but has contact information for all the suppliers. Hence, my goal is to retrieve the contact information from Source B and match it to the suppliers of Source A.

The above can be easliy achieved using a vlookup funtion. But the problem is that some of the supplier names in the two lists are not exact matches. Hence, vlookup does not catch it. For instance, a supplier is listed as ABC Inc. in A list and as ABC, inc. in the other.

Please advise what is a good way to find the matches, when they are not exact. Putting "TRUE" as the last parameter in the vlookup function doesn't work as it is too broad.

Thanks,
Vidita.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,318
Have you tried using pattern matching with last parameter of VLOOKUP as False?
 

vidita

New Member
Joined
Mar 28, 2007
Messages
8
Hi!
Thank you for your response
I have not used that as I have never heard of it. Can you please elaborate?
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,318
Pattern matching is where:

"abc*" finds anything that starts with abc.

"abc?" finds any four character string that starts with "abc"

* stands for "anything (including nothing)"
? stands for "any single character"

Pattern matching works with Find,Replace,Match,Vlookup and other string functions (but not all).
 

Forum statistics

Threads
1,181,367
Messages
5,929,552
Members
436,677
Latest member
CathalP1992

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top