iferror(index(match))) or VLOOK: possible to search for cells only with part information?

Hi guys,

I'm wondering if its possible to use iferror(index(match))) or vlook function to lookup other values/cells in other documents - but be able to look up that cell even though they are not 100% similar. is this possible? would be super helpfull to me.

For instance;
if I vlookup the cell "Eltek ASA", but the cell contains "Eltek ASA - Cognos Campaign", then it would still be able to recognize it.
or if I look up "Försäkringskassan" but the cell is "Forsakringskassan" it would be smart enough to recognize they are the same.

Any help/clues if this is possible I would appreciate it. This would make my work alot easier


Chris