Hello,

I am new to this forum. I am a beginner user and looking for help.

My excel file has Sheet 1 and sheet 2. Sheet1 has Employee name and employee number, whereas sheet 2 has only column of employee name.I am looking for a function or macro to match or partial match(atleast 70%) the Names column comparing sheet1 to sheet 2. Output should give Employee number and employee number.

For instance Simmy Karl Mcmahon is matched with Karl Mcmahon or Simmy Karl.