Merge two workbooks

II have two excel files. One has the proper addresses I need for each company; the other has the proper ID codes I need for each company; easy so far right? There are only two fields that could be used as the “common denominator” Company field or Postal Code field. Unfortunately because of inconsistencies in spelling or partial missing information within these two fields it makes it impossible to merge these two sheets. Any Ideas? If there are programs out there that can sort this type of task, at this point, I’m willing to dish out a few bucks to get this done.

Originally Posted by jwright650

Are you familiar with the use of Wildcards?

Unfortunately I am not