Comparing 'Master' List to a 2nd List

  • Thread starter Thread starter carlos
  • Start date Start date
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.
 
Try pulling out the first 4 letters and adding a wildcard:

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

HTH
Jason
Atlanta, GA
 
Back
Top