sorting table data

There is a table listing the products that production uses. There is also a second list of products. Which formula can be used to check each line against a large list of positions, and in case of a match, transfer the data, according to the principle of the VLOOKUP formula. The main difference is that you need to check the names not with one meaning, but with a large list