sorting table data

Occasional Visitor
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
 

 

 
 
 
 
 
1 Reply

@Bottom2195 

Please attach a small sample workbook.