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.