Does Excel allow price parsing?

Question

excel

The task is this: there are two price lists, the positions intersect, but there are unique ones, in one of the price lists there are spelling errors in the names. You need to make automatic output of data from these price lists to your table.
Questions.
1. Can this be done in principle using Excel?
If yes:
2. Is it possible to prescribe the substitution of values ​​for cells with errors? For example, there is “white paper”, it must be replaced with “white paper”. I can do it with my hands once, but you need to make the current price list every day. You understand - I'm looking for a solution.
In general, I understand that it is difficult to describe the actions here, so tell me the terminology. I just don't understand how to ask Google these questions.

Answer 1

The answer to your questions:
1. You can. Rather, even only by means of Excel (that is, without resorting to vba, if the tables allow)
2. It is possible. To do this, simply check these 2 positions (from different tables) with regular expressions and edit the erroneous one accordingly.