Comparing 'Master' List to a 2nd List

C

carlos

I have a master list (List1)...

Company Name
Gargoyle Inc.
Goldman Company

And a 2nd list (List2)...

Company Name Sales
Gargolley Company 10
Goldman Inc. 20

List2 has the same companies as List1 but are "mis-
spelled".

I tried using the vlookup and setting the range_lookup to
both true and flase and neither worked.

Can you suggest a way to work-around the "mis-spelled"
names on List2 ?

Thank you in advance.
 
J

Jason Morin

Try pulling out the first 4 letters and adding a wildcard:

=VLOOKUP(LEFT(A1,4)&"*",---,---,---)

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Don't want to return blank records 3
Comparing 2 Customer Lists to Identify Shared Customers 2
not exact duplicates... 3
Changing the text within a function based on a cell reference. 2
Top 5 in a List - Alterntive to Pivot Table 1
Compare text in 2 different files 2
List cell values seperated by comma if criteria met 2
Compare City and State to Master List 2

Top