Compare two different Excel table

[Bekzod]

I have to compare values of list of items in two different Excel tables. Items in both tables are essentially the same. It's just items in one table is old version and in another is new version. For instance, ballistic helmet and helmet,ballistic are the same thing. As names doesn't match I can't use MATCH function. There is another file where old and new names are listed side by side to search. I can't think of logic and what formula to use so that I don't have to search individually each item name and compare their values. Community please help

 

[hajiali]

There is another file where old and new names are listed side by side to search

You can use Duplicate conditioning formatting that will highlight duplicate between each

 

[Skybluekid]

Have you tried the Search Function? For Example, =SEARCH("ballistic",helmet,ballistic).