matching partially same product names from 2 different sheets

[sandubandu]

I have two product lists in Sheet 1 and Sheet 2 in both sheets products are same but their naming convention is different.

For example:
'4 QUIN EYE 5GM OINTMENT' is written as '4 Quin 0.005 5gm Ointment'
'4 QUIN KT DROP' is written as '4 Quin KT 5ml Drops'
'ALPROXEN 400MG TAB' is written as 'Alproxen 400mg 10 Tablets' etc.

I have no knowledge about macros and with the help of lookup and match function I do this task.
Is it possible to match this type of data ?
please help !

File is attached for your reference.

[JBeaucaire]

This is the kind of thing you may have to work on manually once, then you could match them after that using a table you created.

1) Copy all the codes from sheet1 and sheet2 into a 3rd sheet putting all the codes in column A together.
2) Now manually add the matches for each item into column B, if the code in A is from sheet1, add the match from sheet2. Do this with the whole data set.

Now you have a lookup table.

Use that as the basis for looking up data from sheet1 on sheet2 by first looking up the correct sheet2 code on sheet3.