I have two lists of data in two separate sheets. I think I need to use
VLookup to compare the two. Is there a way to set the amount of characters
for the "approximate" match criteria?

for example i match
"CALIMETRICS" to "Calimetrics, Inc." which is good.

But I also match a ton I don't want. For example, I match:
"ABBA INDUSTRIES" to "Abbott Diabetes Care."

If i could limit the characters it compares that to, I think it might be
easier to get an accurate comparison.

Thanks for your help,
Mark