How to match in 2 sheets with columns with non exact Text data ?

[Faisal85]

Good Day, Gentlemen’s

I have a issue, which been bogging my mind for sometime, and I need a fix for this problem either VBA or Macros

I have 2 sheets,
(sheet 1) contains employee ID and include a column with employees development needs which I require to compare it with sheet 2
(Sheet2) contains training courses ,it also include employee ID

what I need to do is compare & match the text between the employees development needs column (sheet1) with course titles column (sheet2), it’s must match the correct Emp ID, also to take note that the 2 columns are not 100% exact some cells will be matched some are barley matched. Example shown below.

(employees development needs)
20-02 TE 3.2 6B ANALYSE CONTROL SYS FUNCTIONS, COORDINATE REMEDIAL ACTIONS

(course titles)
20-02 TE 3.2 4B CHECK DATA ACCURACY,SYS FUNCTION,REPORT DISCREPANCIES TO 190912


also to be noted, This data with be updated on daily basis, VBA or Macros should be usable for the future.

[prasadavasare]

How do you compare manualy for two columns....the example you stated above has different ID's.

[Faisal85]

sorry for the long replay

for the ID, most of the times i do Vlookup, after i filter all the data.