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


Please attach a small sample workbook.