Populate Based on Approximate Text

[Kumara_faith]

Hi,

I have two sets of data. One row in sheet 1 houses the selected name of the outlets across the country.Another row in sheet 2 house the master list of all outlets across the country.

The first list and the second list does not match entirely in terms of their order of name.

Example: Name A : BHN Concept Batu Pahat
Name B : Concept-BHN Batu Pahat

I need to know if there is a way via VBA that we could populate the approximate name from the master list in sheet 2 to the data list in sheet 1 ( maybe in column B). That means the codes should compare every text string in a cell in sheet 1 and compare that with every text string in the cell in sheet 2 and then populate the approximate match in column B in sheet 2.

Is this possible ? Appreciate all the help.