I am looking for a way to change the precision of a vlookup using 'TRUE' I have a large data set that has many repeated values that are slightly different in formatting and I need to attach the same identifier to each iteration of these text values. eg:

Discovery Company, Ltd
Discovery Co. Limited
Discovery Company Limited
Discovery Co., Ltd.

Any ideas . . ?